Output Phone to Format

[ebizleads]

I have phone numbers in my table that I query that are 10 digit strings. They have to be this way to load into software to dial.

However, I want to have a query output to:

***-***-****

How do I do this?

Ebizleads

 

[r937]

mid(phone,1,3)&'-'&mid(phone,4,3)&'-'&mid(phone,7,4)

r937.com | rudy.ca

 

[PHV]

You may also try to play with a format like 000\-000\-0000

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886