You can create a UDF (in SQL - not CF) that mimics the "listfind" function, then loop through list "A" and check list "B". I have a blog on how to do that UDF.
http://mkruger.cfwebtools.com/index.cfm?mode=alias&alias=sql%20udf%20listfin d -Mark P.S. Obviously, storing lists in columns doesn't lend itself to optimal SQL code. I wouldn't expect this to be very efficient or easily maintained. -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 05, 2005 5:24 PM To: CF-Talk Subject: RE: SQL Question. Compare one list to another I've got a table with a column that holds a comma seperated list of keywords. I'm just not seeing the solution right now. I've got a keyword search where the user can put in a comma seperated list of keywords. I need the query to search the DB to see if any of the keywords match the keywords in the keywords column. I'm sure it's right in front of me -- John Wilker Writer/Web Consultant www.johnwilker.com / www.red-omega.com Without pulling those lists out into a more normalize structure, the first thing that pops into my head is a series of like matches. WHERE Keywords LIKE '%KeywordMatch1%' AND|OR /*Depending in if they need to match one or all*/ Keywords LIKE '%KeywordMatch2%' AND|OR Keywords LIKE '%KeywordMatch3% /*continue until all keywordmatchs are accounted for. Not very pretty, and I doubt it would be a quick performer. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226131 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
