Add 9 To Phone Number Field

[surfbum3000]

I have a table with a field for the phone number
tblCaseNos.HOME_PHONE

The phone number is 10 digits long. I need to add the number 9 in front of each number in the database.

 

[Johnny42]

Run an UPDATE Query adding the 9 to the record.....

 

[surfbum3000]

I tried this and it did not work:

UPDATE tblCaseNos SET tblCaseNos.HOME_PHONE = "9" & [HOME_PHONE]

 

[surfbum3000]

Please ignore the last post. The code worked.
UPDATE tblCaseNos SET tblCaseNos.HOME_PHONE = "9" & [HOME_PHONE]