I am searching a field on a layer in ArcGIS Server 10 with wildcards.

The query will be something similar to "STREETNAME like '%MAIN%'"

Right now the searches are case sensitive, so it will only return results with MAIN in the STREETNAME field as opposed to Main.

Is it possible for me to disable case sensitive searching?

Thanks, Seth

  • what is your data store? i'm on sql server 2008 and like statements are case insensitive, so STREET_NAME LIKE '%MaNgO%' and STREET_NAME LIKE '%MANGO%' return the same results. Sep 30, 2010 at 15:29
  • File GeoDatabase Sep 30, 2010 at 15:46

1 Answer 1


You can use a SQL function to modify the value before making the comparison. Example:

upper(STREETNAME) like '%MAIN%'

The SQL function may vary from the example depending on the datasource (file GDB, SDE, etc).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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