hi team ,
in my folllowing simple query today i got some inappropriate exponential values like -3.10891025752239E+38 due to this i got error in my application.
following is the query :
select sum(col1)- sum(col2) as diff
where id = @id -- here some id comes from proc
and in col2 there are some exponential values that causes error, please help me to avoid these exponential values getting in my query. i want that no exponential values should be selected by query. i tried isnumeric() but it didn't work.