I have a query with me, earlier it"s worked fine,Now i am getting this invalid number exception.
|SELECT NUM, VALUE FROM deposit|
CASE TYPE WHEN "SAV"
END) > 100
Please suggest me
check the datatype of the column "VALUE " may be it is varchar.
If your value column is having data anything other than number also it will through same exception.
Mentioned exception will occur only when you are trying to convert string to a number.
If your value column is having "," comma in it also you will get same exception.