Formatting Phone Numbers

[stretcher25]

All my phone numbers in my database are in the format of xxx-xxx-xxxx

Is there an SQL query that can change the format to (xxx)xxx-xxxx ?

[russell]

whats the db? for ms sql:

SELECT '(' + LEFT(phone, 3) + ') ' + SUBSTRING(phone, 5, 8)