Maybe you where thinking of
select col INTO var ...