select concat(ISNULL(FirstName,''),' ',ISNULL(LastName,''))
ISNULL
select (Isnull(@fname,' ')+''+Isnull(@lastname,' ') ) as fullname ;
select Trim(FirstName + ' ' + LastName) as fullname from tablename;
select Trim(FirstName & ' ' & LastName) as fullname from tablename;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)