Search Widget Case Sensitive For One Layer But Not Another

JasonMitchell

Making a simple WebMap for users in the company to look at.  In the search widget, I added two layers (Leases & Wells).  For the lease layer expression, I have;  LEASENO like ('%[value]%') or LESSOR like ('%[value]%') or LESSEE like ('%[value]%') - this works fine.  Upper/Lower doesn't matter.  The table data is in caps and when entering 'miller' as a search item, it returns everything with 'MILLER' just fine.

Now for my wells layer expression, I have;  WellName like ('%[value]%') - however, when testing it out, it only returns any results if the search value is entered as all caps, as the data in the table is. 

I've made sure that my field names are correct and still cannot come up with any reason why one layer will work correctly but the other won't.

I'm sure it's something simple - but would appreciate any feedback/help you may provide.

Thanks.

AntGiles

Jason,

How is your data stored for each of your layers? In my experience, if you are using an enterprise database like SQL server then your searches will not be case sensitive. If your data is in a file geodabase then it will be case sensitive.

Your best solution is to use the upper or lower function on all of your queries

Regards

Anthony