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

Home -> Community -> Usenet -> c.d.o.tools -> Re: a "not like" operator?

Re: a "not like" operator?

From: Martin Drautzburg <drautzburg_at_altavista.net>
Date: 11 Apr 2001 03:32:37 +0200
Message-ID: <87puekkyq2.fsf@altavista.net>

"Huoy-Jii Khoo" <khoo_at_mcw.edu> writes:

> Hi,
>
> I know there is a like operator and I can't the "not like"
> operator.... Is there something like that in Oracle?

I know its hard to believe, but the not like operator is "NOT LIKE" as in

select * from a_table where y not like 'foo%'; Received on Tue Apr 10 2001 - 20:32:37 CDT

Original text of this message

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