title: Sorting (or usage of ORDER BY clause) in T-SQL / SQL SERVER without considering some words
body: <p>i'm wondering whether it is possible to use ORDER BY clause (or any other clause(s)) to do sorting without considering some words.</p>
  
  <p>For ex, article 'the':</p>
  
  <ol>
  <li>Bank of Switzerland </li>
  <li>Bank of America  </li>
  <li>The Bank of England</li>
  </ol>
  
  <p>should be sorted into:</p>
  
  <ol>
  <li>Bank of America</li>
  <li>The Bank of England</li>
  <li>Bank of Switzerland</li>
  </ol>
  
  <p>and NOT</p>
  
  <ol>
  <li>Bank of America</li>
  <li>Bank of Switzerland</li>
  <li>The Bank of England</li>
  </ol>