Environment

715 server & dev studio
Backend Oracle

I have a parameterized Search Screen
The HTML form contains many fields, but in this case I am working with LASTNAME and FIRSTNAME edit boxes, In Dev Studio application html pages was developed with tool. The edit fields have the TRANSFROM uppercase on.

Scenario: 1
If CAPS LOCK is on and I enter %UWI% on the lastname entry I will get results in the two iframes on the HTML form. This scenario works perfectly well and generates a LIKE statement

Scenario : 2
If CAPS Lock is off and I enter %UWI% on the lastname entry I will get no results. When I mean no results both iframes initialize bank to blank(it seems
no call is made to WF server). I have SET EMPTYREPORT ON on my reports theirfore norecords should be displayed at all times with the column headers in place.

Has anyone run into something like this before? Is my issue with the % not being translated when in lower case?

Any feedback would be great.

This message has been edited. Last edited by: Kerry,

WebFOCUS searches are always case sensitive irrespective of OS.

Use the UPCASE function on the variable

 -DEFAULTS &COUNTRY='Eng';
TABLE FILE CAR
PRINT CAR MODEL SEATS
BY COUNTRY
-SET &UWHERE = (UPCASE(&COUNTRY.LENGTH, '&COUNTRY.EVAL', 'A&COUNTRY.LENGTH') || '%');
WHERE COUNTRY LIKE '&UWHERE';
ON TABLE PCHOLD FORMAT HTML
END