Disable Case Sensitivity for Queries in ArcGIS Server 10

Question

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

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).