I think what you want is:
where (this_field not like '#this_item#%') and (this_field like
'%#this_item#%')
Note that there's a % at each end of this_item in the second clause.
--Ben Doom
Programmer & General Lackey
Moonbow Software
: -----Original Message-----
: From: JS [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, October 10, 2002 10:49 AM
: To: CF-Talk
: Subject: OT DB field contains but is not first list element
:
:
: I have a situation where I have a list of elements in
: a db field and I need to pull the records where an
: item appears somewhere in the list but is not the
: first item. Something like
: WHERE (this_field NOT LIKE '#this_item#%') AND
: (this_field LIKE '%#this_item#')
:
: It is a SQL 7 db.
:
: TIA,
: JS
:
: __________________________________________________
: Do you Yahoo!?
: Faith Hill - Exclusive Performances, Videos & More
: http://faith.yahoo.com
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
