Correction - it will work for the first round (where firstname is like "Office"), but then the second round (where firstname not like "office") - I receive the PK violation....

So . .. if I

GROUP BY

PRContactAssoc.WBS1, Contacts.ClientID, PRContactAssoc.Role

Will this mess up the PK which is comprised of the first 2 of 3 in the GROUP BY?  When I try adding...

Excellent - Thanks!  I had just got it to work (rather accidentally - with this code) - when I read your post suggesting the same technique.  THANK YOU!!

SELECT     Contacts.LastName, Contacts.FirstName,...

I tried suggestion above with this code:

UPDATE Contacts

   SET memo = 'Previous Employment:  ' + CONVERT(varchar(8000), Previous_Employment)

  FROM Contacts  JOIN ContactCustomTabFields ON Contacts.ContactID = ContactCustomTabFields.ContactID

 WHERE Previous_Employment IS NOT NULL

and received...

This code:

UPDATE

Contacts

SET

Memo = 'Previous Employment:  ' + ContactCustomTabFields.Previous_Employment

FROM

Contacts

INNER JOIN

ContactCustomTabFields

ON

Contacts.ContactID = ContactCustomTabFields.ContactID

WHERE

ContactCustomTabFields.Previous_Employment is not null

Results in this error (despite both fields being type "text")

Server: Msg 403, Level 16, State 1, Line...

Can't a combination of "union all" and "insert" be used to accomplish this?

Ok.  Here is what I actually want to do.  I want ContactCustomTabFields.TextTransfer AND ContactCustomTabFields.Previous_Employment to be inserted into the empty/null field:  Contacts.Memo

All of the fields concerned are of type text. ...

Using "+" in the formula causes me to get an error stating that "+" is for numbers, not text.  That is the error I've been getting along when trying methods...

Problem Solved - thanks! (code)

update EM

set  EM.Address1 = Employees_Home_Address.StreetAddress,EM.[City] = Employees_Home_Address.[City],EM.[State] = Employees_Home_Address.[State],EM.ZIP = Employees_Home_Address.ZipCode

FROM

EM

INNER JOIN

Employees_Home_Address

ON

EM.Employee = Employees_Home_Address.Employee

In this particular case, the html code is before the text we need and is the same string for each field.  This might be as simple as a "trim left"...