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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove characters from text fields 1
Add character to string 2
Select based on 1st character 5
strip numeric characters from a text field 5
Find start position of the 9th occurance of a <character> in a str 2
String Query 3
simple "add to beginning of string" query 6
Character string 1

Back
Top