Case insensitive select statement?

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 - 13:52:07 CDT