Actually, you'll want to use AND, not OR. Otherwise you will return all
rows in the table. Other than that, it should work as you described.
Thanks,
Eric
"Bosky, Dave" <[EMAIL PROTECTED]>
09/15/2003 09:02 AM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: Selecting specific data using LIKE>
I have a field called items(varchar 25) and need to select all rows that
don't contain 'PLAN' or 'FEAT'.
Would I use something like 'WHERE (ITEMS NOT LIKE '%PLAN%' OR ITEMS NOT
LIKE
'%FEAT%')?
Thanks,
Dave
HTC Disclaimer: The information contained in this message may be
privileged and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer. Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:6
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
