title: SQL Query - Greater Than with Text Data Type
body: <p>I've searched around and couldn't find an answer anywhere.</p>
  
  <p>I'm querying a database that has stored numbers as a <code>VARCHAR2</code> data type. <br/> I'm trying to find numbers that are greater than <code>1450000</code> (<code>where BI_SO_NBR &gt; '1450000'</code>), but this doesn't bring back the results I'm expecting.</p>
  
  <p>I'm assuming it's because the value is stored as text and I don't know any way to get around it.</p>
  
  <p>Is there some way to convert the field to a number in my query or some other trick that would work?<br/>Hopefully this makes sense.</p>
  
  <p>I'm fairly new to SQL.</p>
  
  <p>Thanks in advance.</p>