> ids that are linked to values A and B and C.
If you mean only ID's linked to all three (3) values? Something like this <cfset distinctValues = "A,B,C"> ... SELECT ID, COUNT(Value) AS MatchCount FROM TableName WHERE ID IN ( <cfqueryparam value="#distinctValues#" list="true" cfsqltype="cf_sql_varchar"> ) HAVING COUNT(Value) = <cfqueryparam value="#listLen(distinctValues)#" cfsqltype="cf_sql_ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
