select * from contact where ph1 like '2%'
update contact set ph1type = 'M' where ph1 like '02%'
![]() |
|
Two useful SQL scripts for handling imported mobile phone number prefixes. These batch commands are used in the Settings, Admin-only (password restricted), Data Explorer. Refer to this guide for tips on how to preserve leading zeros when importing or transferring exported contacts via CSV. For a large database there may still be contacts with leading zeros missing on their mobile numbers. This script will display all contact records where the Ph1 cells start with 2. This is a common occurrence where contacts have been imported via CSV and the leading zeros are missing. Open select * from contact where ph1 like '2%' This command will force the Ph1 type to be M for contacts with a Ph1 cell that begins with 02. This is the easiest way to classify a batch of contacts as having mobile numbers in preparation for merge SMS / text messaging. Execute update contact set ph1type = 'M' where ph1 like '02%' You can also perform the queries against the ph2, ph3, and ph2type, ph3type cells.
0 Comments
Your comment will be posted after it is approved.
Leave a Reply. |
Admin
|
![]() "SalesPartner helps me extract maximum value from my
biggest asset - my database". Andrew Duncan www.agentmonday.com |