--You can also use LTRIM and RTRIM on the LastName like you did with the FirstName or you can use REPLACE function like Michael showed in solution 1. UPDATE tbltest SET [EmailAddress] = LTRIM(RTRIM([FirstName]))+ '.' + LTRIM(RTRIM([LastName])) + '@xxx.net' WHERE [EmailAddress] IS NULL
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)