[SQL] Merging two columns into one

[Gary MacMinn]

Hi All,

I have two columns in a table (areacode and phone number) that I'd like to merge into 
one (phone number) containing both sets of info. Could anyone suggest a simple way of 
achieving this?

Thanks,
Gary MacMinn