declare @sql varchar(1000) set @sql='select tblUsers.strFirstName'+ '+' +'tblUsers.strLastName as ''fullName'' from tblUsers' exec(@sql)
-- Name with a space set @sql='select tblUsers.strFirstName'+ '+' + ' ' + '+' + 'tblUsers.strLastName as ''fullName'' from tblUsers'
-- Name with a comma set @sql='select tblUsers.strFirstName'+ '+' + ',' + '+' + 'tblUsers.strLastName as ''fullName'' from tblUsers'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)