search without case sensitivity

Hi,

I would like to perform a simple search, i.e.

select name
from user
where name = 'givenname'

'givenname' stands for a value comming from a web based form. This value
will most likely be entered in lower case.

The problem is that the names in the table are sometimes like 'Givenname',
'GIvenname' and also 'GivenName'. So here's my question: How can I perform a
search that will work without case sensitivity?

T.i.a.
Joachim Received on Thu Sep 05 2002 - 10:23:05 CEST