i need to write a condition in my query where my column value is greater than 2
my column name is sales..and when ever the value in sales in greater then 2 i should get the O/P
but datatype of my column sales is "nvarchar"
i have used the condition
cast(isnull(sales,0) as float)>2,
but this didnt work.
if some one could help me ...
View Complete Post