title: SQL Select Specific Records based on Text Value
body: <p>I have a table of Countries.... </p>
  
  <pre><code>CountryID     CountryCode    CountryName
  1              AF             Afghanistan
  2              AX             ALAND ISLANDS
  3              AL             Albania
  4              DZ             Algeria etc.
  </code></pre>
  
  <p>I am going to use this to populate a drop down menu on a web page. What I would like is to be able to have the four countries below appear first, then have the entire list appear below these four in ASC order.   </p>
  
  <pre><code>CountryID    CountryCode     CountryName
  236            US             United States
  40             CA             Canada
  76             FR             France
  235            UK             United Kingdom
  </code></pre>
  
  <p>I have tried various approaches but not gotten it yet.</p>
  
  <pre><code>SELECT *
  From [dbo].[tblCountries]
  WHERE CountryID IN (236,40,76,235)
  ORDER BY CountryName asc
  </code></pre>
  
  <p>This gives me the 4 countries I want, but does not allow me to display the another below them.</p>