Re: Case Sensitive

[Rick_Creel@AONCONS.COM]

How about this idea...

let $partial_name = upper($user_input)
let $likename = '%' || $partial_name || '%'
begin-select
cust.company_name
   let $found_name = &cust.company_name
from customer_table cust
where upper(cust.company_name) like $likename
end-select






Deborah DeCarvalho <ddecarvalho@IBELONG.COM> on 06/01/2000 11:49:24 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rick Creel/IT/Aon Consulting)

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