> Just use multiple LIKE statements > > COLUMN LIKE '%MORE MESSAGES TO FIND%' > OR > COLUMN LIKE '%MORE%' > > Etc
Actually you would only need 4 in this example since finding "more" or "messages" or "to" or "find" will also find any records containg any combination of the above words. You could therefore do a loop of the format... WHERE 1 = 0 <cfloop list="#your words#" delimiters=" " index="i"> AND column LIKE '%#i#%' </cfloop> As mentioned though, with a lot of records this will be sloooowwwwww. -- Jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
