What flavour of SQL is it?

This might do it...
select Qty, Desc, Cast(Qty as varchar)+Desc as Combine from...