Is it possible to pass a comma delimited list of integers as a parameter into an IN function like this?

SELECT *
FROM MyTable
WHERE MyID IN (@MyVar)

'MyID' is an INT datatype and I'd like '@MyVar' to equal 1,2,3.

Many thanks in advance.

TML

I generally feed my CSVs into a table with something like this....

Simple SQL CSV to Table Code Bank

and then I join to the table.

try like this
declare @MyVar varchar(32)
set @MyVar = '1,5,7'

SELECT *
FROM mytable
WHERE '%,'+ @MyVar+',%' like '%,'+ convert(varchar(32),myid)+',%'

That's perfect!

Thanks for your help.

TML

welcome yaar

Be aware that the LIKE solution doesn't scale well. It guarantees a table scan, so on large tables it will be slow.

The solution that Thrasymachus proposed works against a column value instead of an expression, so it can use indicies. It will scale well against the largest tables you can create using SQL Server.

-PatP