If you have the comma delimited list of values stored in a single field in the database, how can you do a select statement to get all of the records that have a certain value as one of the values in the comma delimited list? In this case, I'm trying to assign multiple classifications (classifications are stored in lookup table) to one particular image record (foreign keys from lookup table are stored in the comma delimited list.) Am I approaching this in the wrong way?
Thanks, Jon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2830 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
