Hi All,
I did a query about getting the length of a field value and it works for me (SQL Len()). Say phone number "94166381083" total of 11 numbers, I want to eliminate the first number on the left which is number "9" to get only the 4166381083. I'm having a problem on how to create a query to solve this. Please anyone who have an idea, i really appreciate it.
Thank you.
Best regards,
Jerry
I did a query about getting the length of a field value and it works for me (SQL Len()). Say phone number "94166381083" total of 11 numbers, I want to eliminate the first number on the left which is number "9" to get only the 4166381083. I'm having a problem on how to create a query to solve this. Please anyone who have an idea, i really appreciate it.
Thank you.
Best regards,
Jerry