format data already in a table

[barra47]

I have a table with about 1000 contact names and details

The PhoneMo field has numbers eneterd as 0812345678

I want to alter the data so that it reads 08 1234 5678
Is this possible

Thanks in advance

 

[PHV]

UPDATE yourTable
SET PhoneMo=Left(PhoneMo,2) & ' ' & Mid(PhoneMo,3,4) & ' ' & Right(PhoneMo,4)
WHERE Len(PhoneMo)=10

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

 

[barra47]

Thanks PH

That worked a treat
saved me a lot of work
Excellent