Need to overcome why SQL select cannot find range between tens of thousands and hundreds of thousands
Posted on 2009-04-07
If I run:
WHERE (x BETWEEN '422813.12' AND '487186.88')
AND (y BETWEEN '75113.12' AND '139486.88')
I get zero results. Which is not true because If I run:
I get this result x = 459,200 y = 106,000
By eye I can see this is in range. So, I changed the last line of my SQL to
AND (y BETWEEN '100113.12' AND '139486.88')
Notice the low range has changed from 75113.12 to 100113.12 so it is not tens of thousands but hundreds of thousands and then for whatever reason it finds results!!!! How frustrating.
Anyway, is this a known bug? Is there a work-around? Do I just need to format the number somehow so SQL Server 2005 can recognise it?