SQL Server store multiple values in sql variable -

i have following query:

select *  cars  make in ('bmw', 'toyota', 'nissan') 

what want store parameters in sql variable.

something like:

declare @caroptions varchar(max); select @caroptions =  select distinct(make) carsforsale; print @caroptions; select * cars make in (@caroptions) 

problem print of @caroptions has last result returned from:

select distinct(make) carsforsale; 

i want store multiple values.

any ideas?

you can use table variable:

declare @caroptions table (     car varchar(1000) )  insert @caroptions values ('bmw') insert @caroptions values ('toyota') insert @caroptions values ('nissan')  select * cars make in (select car @caroptions)