combining contents of two fields into a new field?

Hi folks,

Please excuse this question for it shows my ignorance;-)

I need to combine the contents of three different fields into a single
field. I understand how to perform an update on a field with the contents
of another field via a query like:
UPDATE dice_data SET dice_new_phone = dice_prefix

I need to update this field with a concatenation of three fields actually.
What I am ignorant of is how to perform such an update. WOuld someone
kindly guide me in how to perform such an update?

Thanks in advance8-)

Bill Stotts

ps-please reply to me directly as well as the mailing list.

**************************************************************************
Bill Stotts | Voice: 860-616-7535
wstotts(at)sonitrol(dot)net | Fax: 860-616-7589
Sonitrol Communications Corp. |
|
_SONITROL_ Expect the best... | Where do you want to GO tomorrow?
**************************************************************************