UCase with Prompting query 1

[mdlaugh1]

I have a prompting query to enter a specific AREA or * for all. The backend is Oracle and Area values are entered in Upper case. I want to force the value entered at the prompt to UPPER. The following code does not pull any records. when I remove the UCase function and answer the prompt with upper case text I get records... help -- thanks!!


Select UCase([AREA]) AS UArea
Where ((UCase([AREA])) Like [Enter the AREA or * for all] & "*")

 

[PHV]

SELECT AREA, ...
FROM ...
WHERE AREA Like UCase([Enter the AREA or * for all]) & '*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mdlaugh1]

That did it! As usual I was making it too hard...
Star to you! thanks for your continued great help. ml