Help Please

[soleed]

Update Query Help please

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

 

[JVermast]

You will need to create and update query with the criteria "+%%%3*" and the update as "+%%%71*"

Should work for you.

 

[soleed]

You will need to create and update query with the criteria "+%%%3*" and the update as "+%%%71*"

Should work for you.

when i do this query he tell me u will update 0 records

UPDATE Contacts SET Contacts.MobilePhone = "+%%%71*"
WHERE (((Contacts.MobilePhone) Like "+%%%3*")) ;