DECLARE @t table(Col1 char(1),Col2 char(1),Col3 char(1));INSERT @t(Col1,Col2,Col3) VALUES('a','b','c');SELECT ColFROM @t as TCROSS APPLY (VALUES(Col1),(Col2),(Col3)) AS CA(Col);