0
It is obvious to me that the phone number should be stored unformatted; that is, just the numbers.
0
ill give an idea, might works...
select REPLACE(REPLACE(REPLACE(REPLACE('(998) 562-7255', '(', ''), ')', ''), '-', ''),' ','')
0
Thanks but i have used
SearchQuery = SearchQuery + " and (MobileTelephoneNumber like '%" + txtContactSearch.Text.Trim() + "%')";
this quiry and i want to search by directly number (9985627255) and i store the number like (998) 562-7255
and while serching if i put 9985627255 it will not search..
so please help me
for searching the number
thanks
Kamlesh Nikam
0
If this query got resolved then please Accept the post that helped you as Answer.
So other members can easily find the answers.
0
Using SQL LIKE Operator
0
Okay; thank you for the information.