turst
-
Posts
3 -
Joined
-
Last visited
Never
turst's Achievements
Newbie (1/5)
0
Reputation
-
ok, i found that the problem is the inaccuracy in the float. i ended up having to do a < 5.20 AND > 5.18
-
i've tried every combination of single quotes. do you used double quotes?
-
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!