Update Query Help Please

[soleed]

hi,
I Have a tabel with this fields ( Name , Compagny , Phone)
in The Phone all phone numbers are like this follows
+9613430619
And i need to change all records ( 6000 Record) To replace the 3 with 71
so any one can help how i can do this

i did user this update query
UPDATE Contacts SET Contacts.MobilePhone = "+%%%71*"
WHERE (((Contacts.MobilePhone) Like "+%%%3*")) ;

but the result 0 record will change
when i replace -- "+%%%71*" -- With "+96171*"
and -- "+%%%3*" --- with "+9613*"
it replace all the records but the number +9613430619 replace with +9613*


any help please

 

[MStef]

Hello soleed!
Look at "DemoPhoneNumA2000.mdb"
Look at Table1, Query1.
Run Query1, look at Table1.
In any case, take a copy of Table1.