Hi i have a quick question i have a database and i pull the data from it and one of the data im pulling is the telephone number people are entering but unfortunatly the coder that was here before me did not code the form correctly and by this people are able to enter all kind of telephone formats ex:

(123)123-4567, (123)-123-4567, (123)1234567. What i am trying to do is having the output be all the same format when they do a query, i want it to be this format:

123-123-4567

so what way can i achive this..
this is part of my code for the telephone query:

this shows all the telephone numbers in the database regardless of the format but I wish to force a format like the one i specified above.

Thanks.

Don't post the same question in multiple topics.


---------
Rajani