Case sensitive

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"

Ans:
Try

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

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

Ans2:

If you are able to store only upper-case values in that field, that it would
be much better:

select * from table where field = upper(value)

Hosted by www.Geocities.ws