title: SQL Select range for nvarchar column
body: <p>How do I select from tables where the <code>column_a</code> in range 55 -  42000.</p>
  
  <p>Note : <code>column_a</code>'s datatype is in <code>nvarchar</code></p>
  
  <p>I have try like this, but no luck</p>
  
  <pre><code>SELECT 
     SoftwareName, SoftwareImageTeaser, SoftwarePrice, SoftwareDescription
  FROM 
     View_Software_Listing_With_Category 
  WHERE 
     (SoftwarePrice &gt;= '55' AND SoftwarePrice &lt;= '42000')
  </code></pre>