Syntax for IN clause when used in Stored Procedure 1

[forecasting]

I am trying to write a stored procedure where I can pass in the criteria as a single string. For example,

DECLARE @INclause nvarchar(20)
SET @INclause = '''WA'',''CA'''

SELECT City, State
FROM Atlas
WHERE State IN (@INclause)

SQL does not interpret the @INclause as two criteria. Does anybody know how to do this?

 

[gmmastros]

Take a look at this thread (thread183-1232415). It's very similar to what you are asking.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[forecasting]

I think what you are saying is to insert the values into a temporary table in order to use them. Am I correct?

 

[gmmastros]

Yes. The User Defined Function that I show in the other thread makes it easy to do that. It's relatively generic so it will probably work in most cases. Preformance may be an issue if the 'comma delimited list' is large.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[forecasting]

Alas! I was hoping for something easier. Sooner or later, every good idea degenerates into work.

Thanks for the answer.