eSearch Query not working for some expressions

[TomLeMahieu]

Using the eSearch expression configuration, I am able to build my queries.  The problem is that some work and others don't.

For example:

CVTTAXDESCRIPTION = 'CITY OF BIRMINGHAM'              9000+ records

SCHOOLDESCRIPTION ='BIRMINGHAM CITY SCH'           0 records                                                        
CLASSDESCRIPTION = 'RES IMP (INCLUDES PRIOR SI-SUBURBAN IMP.)'      0 records                                   
Upper(NEIGHBORHOODCODE) =Upper('36H')                                                       200+

The ones returning 0 records return the message "No results" immediately.  It's confusing because as you can see below, SCHOOLDESCRIPTION ='BIRMINGHAM CITY SCH' should produce results.  And furthermore, CVTTAXDESCRIPTION = 'CITY OF BIRMINGHAM' does produce results.

Do you have any idea what I may be missing?

Tom

[RobertScheitlin__GISP · Accepted solution]

Tom,

   If you were to add this search expression using the widgets GUI and the field is a type string the the SQL generated by the GUI would normally be:

Upper(SCHOOLDESCRIPTION) = Upper('[value]')

You may want to use the contains option in the GUI which would result in a SQL expression like this:

Upper(SCHOOLDESCRIPTION) LIKE Upper('%[value]%')

[TomLeMahieu]

Robert,

That fixed it!  Thanks!!

Tom