Searching mobile number

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

Kamlesh Nikam15y ago

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

Suthish Nair15y ago

If this query got resolved then please Accept the post that helped you as Answer.

So other members can easily find the answers.

0

Suthish Nair15y ago

Using SQL LIKE Operator

0

Sam Hobbs15y ago

Okay; thank you for the information.

0