QUESTION: Search Widget expression with UPPER

[xandermavrides]

In version 1.x I was able to run the search widget with UPPER as part of my expression (Oracle SDE all caps search)

<expression>PAR_OWN LIKE UPPER'%[value]%'</expression>

However, this statement does not return any results in 2.x. If I use the expression w/o UPPER and type my search string in all caps I get results.

<expression>PAR_OWN LIKE '%[value]%'</expression

[BjornSvensson]

Did you forget the parentheses? The SQL function is UPPER().

<expression>PAR_OWN LIKE UPPER('%[value]%')</expression>

Or if your server has mixed casing content:
<expression>UPPER(PAR_OWN) LIKE UPPER('%[value]%')</expression>

[xandermavrides]

I did forget them() in my post but not in my source code.

I have tried both without luck:

UPPER(PAR_OWN) LIKE UPPER('%[value]%')

And

PAR_OWN LIKE UPPER('%[value]%')

A partial search string works but only if type the correct case in the search box.