Re: Case Sensitive

["Dombrowski, David F" <David_Dombrowski@LORD.COM>]

Deb,

How about:

let $search_field = uppercase($user_input)
BEGIN-SELECT
FIELD_NAME
FROM RECORD_NAME
WHERE UPPER(SEARCH_FIELD) = $search_field
END-SELECT

I think that'll do it. It forces both sides to uppercase no matter how it is
entered or stored.

-----Original Message-----
From: Deborah DeCarvalho [mailto:ddecarvalho@IBELONG.COM]
Sent: Thursday, June 01, 2000 11:49 AM
To: SQR-USERS@list.iex.net
Subject: Case Sensitive


Hi all - I'm stuck on something and looking for some help again..It's
probably staring me right in the face, but here goes
I have an Oracle database which is case sensitive -
I have created a report/interface that allows for the user to enter a
partial or complete
customer name - and the SQR behind it goes to the database and returns the
data on that customer in HTM format to a browser (I know what your thinking
...don't ask...)
Anyway, obviously, if I enter smith and the Customer entered their name as
SMITH, I get no results except SMITH. I need to be able to enter the name in
any case and bring all instances of that name no matter what the case - to
the HTM file.
I have been mucking about with the the UPPER/lower/InitCap commands in
Oracle , but am not having any luck..
Any ideas? Is this easy and I'm just making it too complicated?

Thanks !

Deb de Carvalho