Avatar of biotec

asked on 

Problem casting or converting varchar to int

I run a query such as :
select * from some_table
where someresulttype >='11.0'
and I get far more returned back then I should. I look at the someresulttype column and get many numbers that are less then the 11.0. When I try to do a CAST(someresulttype as int)>= '11.0'
I get:

Conversion failed when converting the varchar value '11.0' to data type int

Avatar of undefined
Last Comment
Guy Hengel [angelIII / a3]

8/22/2022 - Mon