Create Table testdata (lodger c(3), short c(1), id n(2)) Insert into testdata values ('Test','T',1) Insert into testdata values ('ABC','A',2) Insert into testdata values ('UNU','I',3) Select lodger, id from testdata union all; select Cast(short as c(3)) as lodger, id from testdata order by 1,2>i have this data