Converting phone number questions

[jmlbones]

I have phone numbers in a table as "(123) 456-7890" and I need to convert them to "123/456-7890" within a query. Can anyone help?

 

[mikevh]

Use the MID, RIGHT, LEN, and INSTR functions.
Assuming the column with the phone number is called "phone":

SELECT
mid(phone, 2,3) & "/" &
right(phone, len(phone) - instr(phone, " &quot)
AS newphone
FROM YourTable;