Re: Case Sensitive

[Christine Maziarz <MaziarzC@ADAMSGOLF.COM>]

Deb -

Will it work if you set the inputted value to lowercase (or uppercase) and
then match on the lowercase (or uppercase value) of the field you are
matching against in the where clause?

Lame example:

LET $custname = lower($custname)

begin-select
a.custid
xx
xx
from xx
where (lower (a.custid)) = $custname
end-select

I don't think lower is the function you want for Oracle, but this should
give you something to try.

Hope this helps.

Christine Maziarz

> -----Original Message-----
> From: Deborah DeCarvalho [SMTP:ddecarvalho@IBELONG.COM]
> Sent: Thursday, June 01, 2000 10: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