Re: a "not like" operator?

True enough,
You can also use the NOT LIKE operator itself:

where columnname NOT LIKE'03%';

Hth,

Steve

Scott Mattes wrote:

> 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 - 11:08:27 CDT