B
Bikini Browser
Can anyone please help me? I need an update Query written and I don't know
how to do it.
Update Query needed...
I want to take 4 existing columns of data (names) in one table and append
them all into one existing column (Fullname column) in the same table.
However if one of the 4 "NAME" columns is NULL, then don't make 2 spaces
between missing data. Each name field in the full name field.
Here are my columns"
Salutation FirstName LastName SecondLastName
Mr. James Jones
Should come out like this.. Mr. James Smith Jones (There should never be
two Spaces between Names.
Versus Mr. James Jones Where there are two Spaces between James and Jones
how to do it.
Update Query needed...
I want to take 4 existing columns of data (names) in one table and append
them all into one existing column (Fullname column) in the same table.
However if one of the 4 "NAME" columns is NULL, then don't make 2 spaces
between missing data. Each name field in the full name field.
Here are my columns"
Salutation FirstName LastName SecondLastName
Mr. James Jones
Should come out like this.. Mr. James Smith Jones (There should never be
two Spaces between Names.
Versus Mr. James Jones Where there are two Spaces between James and Jones