SELECT (fname + ' ' + mi + ' ' + lname) as FullName FROM table
SELECT fname + ' ' + mi + ' ' + lname as combiname FROM table WHERE ...
select fname + ' ' + mi + ' ' + lname as MyColumn from table
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)