Hi there,
I have a requirement when a user signs up to capture their mobile/cell phone number. Then later I send them sms (txt) messages for various actions on my site.
I am using clickatell to send the text message and it is working well. To send the message the phone number needs to be in full international format no + or leading zeros so for US like 12223334444 that is how I will store it in the database and how it needs to be to send an sms message.
To capture the text message I use a Masked textbox like http://www.asp.net/AJAX/AjaxControlToolkit/Samples/MaskedEdit/MaskedEdit.aspxwith Mask format +1 999-999-9999 then I strip out any non-numberic values and store as a varchar in the database. Is this the best way to do this?
Also later down the track I might need to handle other countries.
Thanks