For starter, don't use
SELECT * FROM ...
- it's a much better idea to list the columns you wish to return as it future proofs your app as well as not wasting bandwidth on data you aren't going to use.
And if you do, you can combine fields in SQL:
SELECT EmpNo, FName + ' ' + LName AS [Name] FROM Transfer ORDER BY EmpNo