Mohanjit,
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:
UPDATE Contacts
SET address = FormatAddress(g.Line1, g.Line2, g.City, g.State, g.Zip,
g.Country)
FROM Contacts c, GContacts g
WHERE c.ContactID = g.ContactID
"Mohanjit" <uc.edu> wrote in message
news:phx.gbl...
> have
> would
>
>[/ref]
Bookmarks