declare a variable with multiple items like an in for a where clause?

Question

Is it possible to declare a variable with multiple items like an in for a where clause?

Answer 1

For example:

declare @values varchar(max) = '100,250,30,700'

select *
from MyTable
where id in (select [value] from string_split(@values, ','))

-- OR:

select t.*
from MyTable t
inner join string_split(@values, ',') as v on v.value = t.id