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
californiagirl
Messages: 79
Registered: May 2007
Member
Hi,

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.

Thanks

Californiagirl
Re: Restricting Data using LIKE [message #392662 is a reply to message #392661] Wed, 18 March 2009 16:18 Go to previous message
ThomasG
Messages: 3189
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: Wed Dec 07 22:23:37 CST 2016

Total time taken to generate the page: 0.09265 seconds