Re: a "not like" operator?

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Mon, 09 Apr 2001 14:40:25 GMT
Message-ID: <tRjA6.9966$%N.73195@skycache.prestige.net>

How about

where not ( table_field like '03%')
and not ( table_field like '04%' )

???

"Huoy-Jii Khoo" <khoo_at_mcw.edu> wrote in message news:9ask9f$oqg$1_at_wiscnews.wiscnet.net...
> Hi,
>
> I know there is a like operator and I can't the "not like" operator.... Is
> there something like that in Oracle?
>
> What I was trying to do is to search string with anything EXCEPT those
> starting with 03 and 04.....
>
> Thanks in advance,
> jii
>
>
>
Received on Mon Apr 09 2001 - 09:40:25 CDT