How to delete the 1st character of a numeric string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 9 in the front of phone numbers that I need to remove in order to do
a comparison query.
 
With a use of Mid function to create another field that start from the second
digit

NewPhone:Mid([PhoneFieldName],2)

Or, In SQL:

Select TableName.*, Mid([PhoneFieldName],2) As NewPhone From TableName

In the comparison you can use the new field created
 
Back
Top