title: Conversion failed when converting the nvarchar to int
body: <p>I have a field which is varchar and contains numbers and dates as strings. I want to update all numbers in this field that is greater than 720. I have attempted firstly to do a select but I get this error:</p>
  
  <pre><code>Conversion failed when converting the nvarchar value '16:00' to data type int.
  </code></pre>
  
  <p>This is my query:</p>
  
  <pre><code>select id, case(isnumeric([other08])) when 1 then [other08] else 0 end
  from CER where sourcecode like 'ANE%' --and other08 &gt; 720
  </code></pre>
  
  <p>It fails when I uncomment the last part.</p>
  
  <p>I am trying to get all numerics greater than 720, but I can't do the comaprison. It also fails when casting and converting.</p>
  
  <p>Thanks all for any help</p>