IN clause and variables 1

[deepsheep]

I'm trying to pass a formatted array to a Stored Procedure and am having problems with the SQL. I know I can use dynamic SQL, but was hoping to avoid using it.

Sample of what I'm trying, it works as dynamic, but not this way:

declare @Param  nvarchar(200),
@cmd nvarchar(2000)
set @Param='(00175072010,00175184020)'

select * from PropertyTable  where pmlinc IN @Param

Any ideas? maybe there's another way?

Thanks!

 

[bborissov]

Check Split function here in FAQ. Tht function retuns table which you can join to your table.

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[deepsheep]

Thanks, that's a huge help!