Re: search without case sensitivity

From: Guido Konsolke <gk61_at_gmx.net>
Date: Thu, 5 Sep 2002 11:24:58 +0200
Message-ID: <1031217398.929014_at_news.thyssen.com>


Comments inline...

"Joachim Liedtke" wrote...
> Hi,

Hallo Joachim,

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

Change your Where-Clause to
where upper(name) = upper('givenname')

>
> T.i.a.
> Joachim

hth,
Guido Received on Thu Sep 05 2002 - 11:24:58 CEST

Original text of this message