How do I dsplay result set selected in

DECLARE @list= varchar(20)

SET @list= ''' + 'Blue' + ''' ',' + ''' + 'Green' + '''';
select name, charchetrstics, type
from my_table
where color IN ( @list)

I execute it using sql managment studio,
it executes fine.

what statement to use inside begin-endblock so that it displays the result set selected by the select query.

print only works for single(scalar) vale...?

thank you