I've seen an example somewhere that was more robust on this, but something like this might help...
SELECT Firstname FROM myTable WHERE Talents LIKE '%dancing,' OR Talents LIKE '%,dancing,%' OR Talents LIKE ',dancing%' OR Talents = 'dancing' - Calvin ----- Original Message ----- From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 1:34 PM Subject: SQL : Finding element in list of values in a query field. > Hey all, > > Say for example I have a table: > > Firstname > Lastname > Address > Talents. > > > Talents for one record is: acting,dancing,singing. > > For another record it is : dancing,singing,music > > > I want to construct a query to find all those with dancing as a talent. > > How would I do that using SQL...*can* I do that using SQL? > > -Angel > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
