Thanks for the quick response, but I should have been clearer in my need.
Basically I want to write a function that will format an address and be able
to include the function call in a batch update as in:
SET address = FormatAddress(g.Line1, g.Line2, g.City, g.State, g.Zip,
FROM Contacts c, GContacts g
WHERE c.ContactID = g.ContactID
"Mohanjit" <uc.edu> wrote in message