But it's a problem.
Upper() will only work properly if facing a field with the right collation,
otherwise only ASCII characters in the range ['a','z'] are uppercased.

C.

> -----Original Message-----
> From: Ungod [mailto:ungod@...]
> Sent: Sábado 24 de Junio de 2000 11:01
>
> err, issue 1 is a no-brainer.
>
> select * from mytable where UPPER(myfield) = somevalue
>
> or even
>
> select * from mytable where UPPER(field1) = UPPER(field2)
>
> --
> Ungod (W.King)