title: Get records ordered alphabetically starting by a certain letter in Sql Server
body: <p>In SQLSERVER/MSSQL, here's the problem:</p>
  
  <pre><code>SELECT * from [Translation Color] order by [Language Code] 
  </code></pre>
  
  <p>I want records ordered in alphabetical order starting by the 'I' letter.</p>
  
  <p>Example of result:</p>
  
  <p>'Ioren'
  'Iumen'
  'Tart'
  'Arfen'
  'Coldry'</p>
  
  <p>I don't want to use union or more sql statements.. just try to catch it with an order by special clause.</p>
  
  <p>I've tried with: </p>
  
  <pre><code>ORDER BY &lt;field&gt; REGEXP '^I' DESC
  </code></pre>
  
  <p>but it didn't work.</p>
  
  <p>Any ideas?</p>