Hello,
I'm trying to run a simple query and I don't know why it's not working. I have a US cities shapefile with an "Population" field and I'm just running this: Select * FROM cities WHERE: POPULATION > '400000'
But it doesn't select populations that are above 400,000. It seems to just select whatever it wants - including cities with a population of 96, 3000, or 500,000. I don't know how it's deciding to select what it does but it selects about half of them with no logic to it.
Any ideas?
