format Australian phone numbers using format function

[HebieBug]

Am extracting a field from an SQL database which holds phone numbers. It is integrated with a PABX phone system and the data needs to be saved as 0295554323. The data should be shown to the user in the format (02) 9555-4323.
Started by using the format function:
format(0#)####-#### it works fine.
Does anyone know of a better way of getting to the desiered result. Rather then having to force a 0 in at the start.
THe reason for this is the live database at the moment has some problems with the data being held, some of it will not even have a (02) at the start but rather just the phone number.

 

[mbpiper]

you can check the length of the field if its 10 then use your format if its 8 then use ####-####.

 

[WilMead]

try format(n, "\(00\)0000\-0000&quot


Wil Mead
wmead@optonline.net