Saturday, 14 February 2015

sql - Select By Attribute: Between Two Numbers



I am trying to select house numbers that are between 200 and 499. I've been using:


"HOUSE_" >= '200' AND "HOUSE_" <= '499'



... and it's coming up with almost everything else. The numbers it does grab don't make sense at all either. I tried using a BETWEEN operator but that just gives me an error.




No comments:

Post a Comment