Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am an IT guy, not a GIS guy. What I know about how to use ArcMap 10 I learned from Google. It has served me well so far. Apparently what I'm wanting to do worked in version 9, but no longer does in the same fashion in 10.

I'm trying to select by attributes on a shapefile. I know that in one type of database you can ignore case, but you cannot in another. I don't know what category a shapefile fits in. I even tried Googling that particular question and couldn't figure it out.

Ultimately, I want to perform a search on a particular column, ignoring case for multiple values. I did have this:

"STRUCSTATE" = 'IL' and ("ENTITY" LIKE '%City%' or "ENTITY" LIKE '%village%' or 
    "ENTITY" LIKE '%town%' or "ENTITY" LIKE '%county%' or "ENTITY" LIKE '%district%')

but it used the exact case I used. There may be any mix of case (including impROper) and those strings could be anywhere in the field.

Help?!

share|improve this question
add comment

1 Answer 1

up vote 8 down vote accepted

To be certain, use a database function to change to the same case...
File geodatabases or shapefiles, UPPER
Personal geodatabases(Access), UCASE

UPPER("STRUCSTATE") = 'IL'
UPPER("ENTITY") LIKE '%CITY%'
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.