Re: Case Sensitive

["Jamadagni, Rajendra" <rajendra.jamadagni@ESPN.COM>]

It would also be worth to point that this will disable index usage (if the
index is on the search column) in Oracle, and your queried would be running
waaaay slower if you are hitting more than a few thousand records.

HTH
Raj
-----Original Message-----
From: Dombrowski, David F [mailto:David_Dombrowski@LORD.COM]
Sent: Thursday, June 01, 2000 7:54 AM
To: SQR-USERS@list.iex.net
Subject: Re: Case Sensitive


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.