OraFAQ Forum: SQL & PL/SQL » Restricting Data using LIKE

Home » SQL & PL/SQL » SQL & PL/SQL » Restricting Data using LIKE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restricting Data using LIKE [message #392661]

Wed, 18 March 2009 16:17

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

Report message to a moderator

Re: Restricting Data using LIKE [message #392662 is a reply to message #392661]

Wed, 18 March 2009 16:18

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Just get rid of that "IN" and then it should work like you want.

Report message to a moderator

Previous Topic:	Question about where-clause in select-statements
Next Topic:	Compilation unit analysis terminated error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 12:58:11 CST 2024