Good Morning, I have a CF list of items with single quotes around them (e.g., list = 'ABC', 'DEF', 'XYZ')
I am trying to use this list in a T-SQL statement using "IN": SELECT * FROM test-table WHERE test-row IN (#list#) The problem is T-SQL adds quotes and I end up with the following statement: SELECT * FROM test-table WHERE test-row IN (''ABC'', ''DEF'', ''XYZ'') Any idea how to stop these additional quotes? Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4