Phone Number Edit

[Joe_Phoenix]

Hi All,

Once again I have a problem I need assistance with.

I have imported approx 90,000 telephone numbers.

Each number is an 8-digit number. Such as 123-4567.

I need to add a 02 in front of all numbers. Can this be done without obviously editing each number individually.

I need to then export this back out to upload to a thir party client.

Regards,

Joe

[Vaughan]

Use the Replace Field Contents command, but specify the result as a calculation:

"02" & telephonenumberfield

Backup before doing this because Replace is not reversible and it's easy to stuff it up. }:(