Solved Update telephone numbers (1 Viewer)

[Number11]

Hello so i need to remove the "0" from telephone numbers and replace with "44"

is this possible via an update query

 

[CJ_London]

Yes, use the mid function

“44” & mid([telno], 2)

 

[XPS35]

CJ_London's solution will work in an update query. If there are numbers that do not start with 0, add a condition to query. Like:
WHERE Left(Telnr) = "0"

 

[Gasman]

Wouldn't you need the + prefix as well if 44?

 

[Galaxiom]

Wouldn't you need the + prefix as well if 44?

The + represents the local international access code. It is not actually part of a phone number.

 

[Pat Hartman]

Wouldn't it be better to store the international access code in a separate field?

 

[Galaxiom]

Wouldn't it be better to store the international access code in a separate field?

Depends on the purpose. The company I work for is implementing a SalesForce system that recognises the caller from the incoming phone number by looking it up in the customer database. They want me to provide the phone numbers exactly as the OP has specified.

 

[Pat Hartman]

Like everything, we have to decide whether to store the data in the most efficient way. Then we interface with the user in the way he wants. will you be storing the "1" for US numbers?