Re: Case Sensitive

[Cherno Jagne <ITSCJ@QE2-HSC.NS.CA>]

Deb,

The soundex() function in Oracle is also a nice one--sometimes.
It probably won't give you a match on partial names but it may
pick up misspelled names or variations in the spelling of a name.
For example, if I may use your name, soundex('Deborah') returns
the same value as soundex('DEBRA')! (note the different spellings
and case).

Cherno.

>>> Deborah DeCarvalho <ddecarvalho@IBELONG.COM> 06/01 1:28 PM >>>
You guys are the BEST !!
Thanks so much..
I will give them all a try  !

Thanks again !!


Deb

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Dombrowski, David F
Sent: Thursday, June 01, 2000 11: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.

-----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