Select *, Ltrim(Rtrim(Last_Name)) + ' ' + Ltrim(Rtrim(First_Name)) as Company from tbl
However if you're showing this information somewhere else like a form or a website then I'd select the two columns as separate fields and do the concatenation in the display layer.