Re: Case-sensitive select statements?

Cherk wrote:
>
> select * from table
> where upper(name) = 'KIRK'
>
> Cherk <andrija.cerkez_at_lijanovici.com> wrote in message news:...
> > select * from table
> > where name = upper('Kirk')
> >

This could cause problems if there is an index on the column 'name'. Received on Tue Feb 15 2000 - 00:00:00 CST