Try (and adapt) this:
<CFSET test="skateboarding atlanta half-pipe">
<CFSET oper = "">
<CFQUERY DATASOURCE="DSN">
SELECT myColumn FROM myTable
WHERE
<CFLOOP INDEX="word" LIST="#test#" DELIMITERS=" ">
#oper# myColumn LIKE '%#word#%' <CFSET oper = "OR">
</CFLOOP>
</CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
