Wednesday, June 26, 2013

Accuracy of float values

I found that this query would give me correct result though

SELECT Id, Num
FROM @Tab
where num between .115-0.0000000000000001 and .115+0.0000000000000001





Satheesh


No comments:

Post a Comment