Re: Case insensitive select statement?

Gary,

Try using the builtin function UPPER and LOWER i.e

select name
from table1
where UPPER(name) like 'A%'

Chris
Gary wrote:
>
> I'm trying to select all records beginning with the letters A, B, C, or D,
> but it must be a case insensitive search.
>
> e.g
> select name from table1
> where name like 'a%'
>
> How can I make it case insensitive please? I'm also trying to select all
> records that contain a phrase, such as "upper or lower case" but again it
> must be case insensitive.
>
> eg.
> select name from table1
> where name like '%upper or lower case%'
>
> Unlike Access, Oracle 8i seems to be case sensitive when selecting records.
> Any suggestions please?
>
> Thanks,
> Gary.
Received on Thu Aug 31 2000 - 14:11:24 CDT