turst Posted December 8, 2006 Share Posted December 8, 2006 Is it not possible to have a WHERE clause check if something is equal to a float? I've tried it with both x = 5 and x = 6 and both work, so my query is fine other than this last part. When i use any number with a decimal, I get no results. 5.19 is a valid piece of data so it should be able to find it. Is there a way around this?Thanks! Quote Link to comment Share on other sites More sharing options...
drifter Posted December 8, 2006 Share Posted December 8, 2006 try quotes??? Quote Link to comment Share on other sites More sharing options...
turst Posted December 8, 2006 Author Share Posted December 8, 2006 i've tried every combination of single quotes. do you used double quotes? Quote Link to comment Share on other sites More sharing options...
turst Posted December 8, 2006 Author Share Posted December 8, 2006 ok, i found that the problem is the inaccuracy in the float. i ended up having to do a < 5.20 AND > 5.18 Quote Link to comment Share on other sites More sharing options...
drifter Posted December 8, 2006 Share Posted December 8, 2006 makes sence - whenever I use float, I do use quotes... but I also use < or > Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.