Solved Update telephone numbers

[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.

 

[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.