<p>I have mixed data i nvarchar column (words and numbers).
Which is fastest way to sort data in this column in Numeric Order.</p>

<p>Result example:</p>

<ul>
<li>1</li>
<li>2</li>
<li>3</li>
<li>...</li>
<li>10</li>
<li>11</li>
<li>...</li>
<li>aaaa</li>
<li>aaab</li>
<li>b</li>
<li>ba</li>
<li>ba</li>
<li>...</li>
</ul>

Cast it.
```
```
SELECT * FROM foo ORDER BY CAST(somecolumn AS int);
```
```
Been a while since I've touched SQL Server, so my syntax might be entirely incorrect though :)