1

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. – Jay Cummins Sep 30 '10 at 15:29
  • File GeoDatabase – Britt Wescott Sep 30 '10 at 15:46
6

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, privacy policy and cookie policy

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