storing ('chris', 'john') in a variable

[christhedonstar]

Hi,

You can do: where columnName in ('chris', 'john') in the where clause. How would I store 'chris', 'john' in a variable and use the variable in the where clause. i.e. where columnName in @names?

Thanks,

Chris