Dear All, I have a column named amount1 varchar(50) in table tbTest . The column have value '0.00' My query is Select * from tbTest WHERE IfNull(amount1, 0) > 0 I expect this query should not return any rows but its returning.How to solve the problem.Is there any way to cast or conversion...