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

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...