Remove 1 from 11digit numbers
Update clients set voicephone=substring(voicephone,2,10) where length(voicephone)=11 and substring(voicephone,1,1)='1'Note: This query will fail if the list contains duplicate phone numbers. It will stop at the point it finds a duplicate. You will have to run the query repeatedly to continue fixing the list.
Related Articles
- Dialing Local Exchanges in SPD Pro
- Scrubbing Lists Against Each Other
- Enabling and Using List Queuing in SPD Pro
- How to manually put a person’s number into the nocalls list. Pro version.
- Enabling and Using Alternate Number Dialing in SPD Pro
Attachments
No attachments were found.Visitor Comments
No visitor comments posted. Post a commentPost Comment for "Remove 1 from 11digit numbers"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.Article Details
Last Updated
2nd of November, 2009
