Home » SQL & PL/SQL » SQL & PL/SQL » Restricting Data using LIKE
Restricting Data using LIKE [message #392661] Wed, 18 March 2009 16:17 Go to next message
Messages: 79
Registered: May 2007

I'm trying to restrict certain data from appearing in my report by using something like below:

AND organization_short_name NOT IN LIKE '%Delete - Change%' 

There are too many different variations that have Delete - Change before the D and after the e in Change, so to avoid putting every variation (200+) in the condition, I'd rather just shorten it by saying LIKE '%Delete - Change%'. Any other suggestions would be helpful.


Re: Restricting Data using LIKE [message #392662 is a reply to message #392661] Wed, 18 March 2009 16:18 Go to previous message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Just get rid of that "IN" and then it should work like you want.
Previous Topic: Question about where-clause in select-statements
Next Topic: Compilation unit analysis terminated error
Goto Forum:

Current Time: Fri Jul 21 12:14:16 CDT 2017

Total time taken to generate the page: 0.08596 seconds