Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- NAME_1 NAME_2 LASTNAME_1 LASTNAME_2
- -------------------------------------------------
- ALISON NULL LAWRENCE NULL
- CARLOS NULL LOPEZ RECINOS
- MEL ANDREA CHEW PHELPS
- NAME1 NAME2 LASTNAME1 LASTNAME2 FULL_NAME
- ----------------------------------------------------------------------
- ALISON NULL LAWRENCE NULL ALISON LAWRENCE
- CARLOS NULL LOPEZ RECINOS CARLOS LOPEZ RECINOS
- MEL ANDREA CHEW PHELPS MEL ANDREA CHEW PHELPS
- UPDATE Table1
- SET FULL_NAME = ISNULL(NAME_1,'') +
- ISNULL(NAME_2,'') +
- ISNULL(LASTNAME_1,'') +
- ISNULL(LASTNAME_2,'')
Add Comment
Please, Sign In to add comment