Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question about not like operator

SeshuGiriNov 5 2010 — edited Nov 5 2010
HI,


This where clause omitting ABC% , but I wanted to exclude some conditions I want my sql to return COLUMNA = 'ABCD' but exclude everything else 'ABC%'
how do I fix this?

WHERE COLUMNA NOT LIKE '%ABC'
AND COLUMNA NOT LIKE 'ABC%'
AND COLUMNA NOT LIKE '%XYZ'
AND COLUMNA NOT LIKE 'XYZ%'

Expected result:
ABCD
AAAA
BBBB
etc
This post has been answered by Frank Kulash on Nov 5 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 3 2010
Added on Nov 5 2010
1 comment
110 views