title: How to search a string(Phone number) which can be stored in different format in mssql
body: <p>I am having a table of customers where we are having phone number field defined as varchar(50). Since there is no validation different customers have saved there phone number in their own preferred way eg</p>
  
  <p>cust1 --> xxx-xxx-xxx</p>
  
  <p>cust2 --> (xxx)xxx-xxx</p>
  
  <p>cust3 --> xxx xxx xxx</p>
  
  <p>this hasn't created any problem till now because no one was searching using phone number.
  After adding search functionality, the client wasn't able to get the desired result because to match you also have to provide the query in same format.</p>
  
  <p>Is there any way I can search the phone column considering only numbers?</p>