How do I pass a list for the IN operator in a variable
634676Mar 30 2010 — edited Mar 30 2010I have a procedure which receives for one of it's IN variables (var1) a comma delimited list of strings. I output the value of var1 to a file so I know it is receiving the full string as...
'700 Number Calls','800 Number Calls','900 Number Calls','Customer Service Calls','Directory Assistance','Emergency/911 Calls','International Calls','Standard Phone Calls','Voicemail'
When manually typing a query using "IN ('700 Number Calls','800 Number Calls',...'Standard Phone Calls','Voicemail')" the query returns three rows
When the procedure does a Select statement using "IN (var1)" no rows are returned. How can I pass the comma denoted list for the IN operator within a single variable?