Case sensitive where clause

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:49:15 CST