I have a 9 in the front of phone numbers that I need to remove in order to do a comparison query.
A Angellou Jul 12, 2007 #1 I have a 9 in the front of phone numbers that I need to remove in order to do a comparison query.
O Ofer Cohen Jul 12, 2007 #2 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
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
