Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case sensitive where clause
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)
Fredy Tschui пишет в сообщении <7d8gjp$ijv$1_at_sibyl.sunrise.ch> ...
>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 - 11:04:51 CST