QUESTION: Search Widget expression with UPPER

317
2
10-06-2010 06:55 AM
xandermavrides
New Contributor
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
Tags (2)
0 Kudos
2 Replies
BjornSvensson
Esri Regular Contributor
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>
0 Kudos
xandermavrides
New Contributor
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.
0 Kudos