Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Case sensitive where clause

Re: Case sensitive where clause

From: Serge <rulsl_at_chat.ru>
Date: Tue, 23 Mar 1999 20:04:51 +0300
Message-ID: <7d8hk5$5dd$1@news2.aha.ru>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US