Re: Case-sensitive select statements?

select * from table

    where name = upper('Kirk')

> However, I want it to return every entry where name is 'Kirk' or 'kirk'
> or 'kirK', etc.
>
> Is this possible?
>
Received on Tue Feb 15 2000 - 00:00:00 CST