How to Find Greater Than of an Alphanumeric String
<p>I have a table that look like below</p>
<pre><code>SalesOrderNo
------------
1
2
D1
D2
D11
D12
D16
D20
D21
</code></pre>
<p>I want to search and find  all the sales order numbers that are grater than D16
this is what I have tried</p>
<pre><code>Select SalesOrderNo From tbl_Sales Where SalesOrderNo &gt; 'D16' and  SalesOrderNo LIKE 'D%'
</code></pre>
<p>and This is What I Get</p>
<pre><code>D2
D20
D21
</code></pre>
<p>But The Desired Out Put is</p>
<pre><code>D20
D21
</code></pre>