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