Solved Update Telephone Numbers (1 Viewer)

[Number11]

Hi So i need to update some telephone numbers and remove the prefix "44"

447999999999

and remove with "0"

 

[Gasman]

So use the string function Left() and Mid() and concatenate with 0

 

[cheekybuddha]

and remove with "0"

Do you mean replace with "0" ?

Where are your phone numbers? In a table?

If so, you can do something like:

UPDATE YourTable
SET PhoneNumber = '0' & Mid(PhoneNumber, 3)
WHERE Left(PhoneNumber, 2) = '44'
;

 

[cheekybuddha]

Oops! I've done @Gasman's bête noire and given a fish rather than a fishing rod and instruction manual (Sorry, gm!)

 

[Number11]

Oops! I've done @Gasman's bête noire and given a fish rather than a fishing rod and instruction manual (Sorry, gm!)

WORKED thanks