Break out the comma dilimited list into a cross ref table then you query the tables with an inner join to get the features.
-----Original Message----- From: Bill Hartley <b...@whdservices.com> Sent: Friday, May 28, 2010 7:37 PM To: cf-talk <cf-talk@houseoffusion.com> Subject: Comma delimited list I am trying to display feature codes from a comma delimited list inside a database. Here is my setup: Table: Listings has a column called FEATURE_CODES and example of the data in this column is "B01,E09,E20,G12,J07" Then I have another table inside the same database called FeatureCodes the data inside this table is arranged FEATURE_CODE FEATURE_DESCRIPTION B01 Sold As Is E09 Frame and Stucco and so on.... I need to display the feature description from the FeatureCodes table on the display page by reading the feature_codes from the listing table Any Suggestions?? Please!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm