Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: a "not like" operator?
"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