Re: Case sensitive where clause

Try

SELECT * FROM table where UPPER(field) = 'X';

However, be aware that this will prclude the use of any indexes on the field.

On Tue, 23 Mar 1999 17:49:15 +0100, "Fredy Tschui" <ftschui_at_logon.ch> wrote:

>Is there any way to prevent case sensitive results from a where clause ?
>
>The following results are different:
> select * from table where field = "X"
> select * from table where field = "x"
>
>Thanx, Fredy
>
>
>
Received on Tue Mar 23 1999 - 10:58:05 CST