topic Re: QUESTION: Search Widget expression with UPPER in ArcGIS Viewer for Flex Questions

QUESTION: Search Widget expression with UPPER

xanderm — Wed, 06 Oct 2010 13:55:01 GMT

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

Re: QUESTION: Search Widget expression with UPPER

BjornSvensson — Fri, 08 Oct 2010 18:21:08 GMT

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>

Re: QUESTION: Search Widget expression with UPPER

xanderm — Tue, 12 Oct 2010 13:56:07 GMT

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.