I'm trying to create a proc (SQL 2000) that takes a single input paramter from a front Cold Fusion app. The parameter should hold a comma delimited string that should look like this: ('00012201', 00055445', '33315511', ...(n)) where the string passed should include the single tick marks and commas. So essentially the proc definitiion would look like this: CREATE PROC getInfo @List varchar(8000) AS DECLARE @StringSQL nvarchar(4000) SET @StringSQL = ( 'SELECT <COLUMN_NAMES> FROM <TABLE_NAME WHERE <COLUMN_NAME IN (''' + @List + ''') AND<COLUMN_NAME <>''' + '1' + '''' ) EXECUTE sp_executesql @StringSQL Where the first <COLUMN_NAME> in the WHERE CLAUSE is varchar(50) and the second <COLUMN_NAME> is varchar(10) I'm having problems getting the app to pass the list correctly, or it throws and error saying it can't convert from a datatype to a datatype. I realize this is a little vague but I don't have experience with Cold Fusion. Any and all suggestions are welcome.