Case Sensitive

[Deborah DeCarvalho <ddecarvalho@IBELONG.COM>]

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