Re: SQL Select statement help needed

text book question
SELECT * FROM Users WHERE upper(Name)='KARASU'

Hth,

Sybrand Bakker, Oracle DBA

<karasu7870_at_my-deja.com> schreef in berichtnieuws 8gjt9m$mk0$1_at_nnrp1.deja.com...
> I want to use a select statement of the form:
>
> SELECT * FROM Users WHERE Name='KARASU'
>
> I want the value for the name I am searching for to be case insensitive.
> Any user with the name Karasu should be returned regardless of case. Is
> there an easy way to do this? Thanks.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu May 25 2000 - 00:00:00 CDT