title: SQL Select Certain Value First
body: <pre><code>SELECT     AssetValue
  FROM         Assets
  WHERE     (AssetType = 'Country')
  </code></pre>
  
  <p>Very simple Select Statement, but it outputs</p>
  
  <pre><code>Afghanistan
  Albania
  Algeria
  ....
  </code></pre>
  
  <p>How do I make United States and Canada appear on the top of this? Is this possible with SQL or do I need to do something in my ASP code? My PK is a INT Identity.</p>