Combine first and last name and update into full name column for each row

Question

For each first and last name I would just like to combine and update them into the fullname column in the same "names" table.

This should happen for every row in the table. The columns are Id, FirstName, LastName and FullName.

Any help would be appreciated

update Names n 
set n.FullName = (
    select CONCAT(FirstName,' ',LastName)  
    from Names a 
    where n.Id = a.Id
)
where n.FullName is null 
and n.FirstName is not null and n.LastName is not null

You could use Update from Select like its explained here: http://stackoverflow.com/questions/2334712/update-from-select-using-sql-server — dacaballero, Nov 18 '16 at 05:47

Mudassir Hasan · Accepted Answer · 2016-11-18T05:53:08.537

4

This UPDATES FullName Colum that are blank or have NULL values.

UPDATE Names
SET FullName = ISNULL(FirstName + ' ','') +  ISNULL(LastName,'')
WHERE ISNULL(FullName,'') = ''

EDIT

UPDATE Names
SET FullName = FirstName + ' ' + LastName
WHERE ISNULL(FullName,'') = '' AND  ISNULL(FirstName,'') <> '' AND ISNULL(LastName,'') <> ''

edited Nov 18 '16 at 05:53

answered Nov 18 '16 at 05:41

Mudassir Hasan

28,083
20
99
133

I would like to skip the row if FirstName or LastName are null so I dont have full names with just first or last name – Sealer_05 Nov 18 '16 at 05:50
and n.FirstName is not null and n.LastName is not null – Sealer_05 Nov 18 '16 at 05:51
Looks Great! Thank you! – Sealer_05 Nov 18 '16 at 06:03

Combine first and last name and update into full name column for each row

1 Answers1