Searching mobile number

Question

hi,
i am developing one application in C# .net and i have some fields including mobil number and i want to search a mobile .
but i have store the mobile in sequence like [phone]
and when ever i am trying to search mobile number 9862585896 it is not showing me a mobile number iot just give me blank. and when i am searching like 986 so it give me searching result

Thanks ...
Kamlesh

Answer 1

It is obvious to me that the phone number should be stored unformatted; that is, just the numbers.

Answer 2

ill give an idea, might works...

select REPLACE(REPLACE(REPLACE(REPLACE('[phone]', '(', ''), ')', ''), '-', ''),' ','')

Answer 3

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 [phone]
and while serching if i put 9985627255 it will not search..
so please help me

for searching the number

thanks
Kamlesh Nikam

Answer 4

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

So other members can easily find the answers.

Answer 5

Using SQL LIKE Operator

Answer 6

Okay; thank you for the information.