title: Regular expression for query to SQL Server
body: <p>I have a SQL Server connection to an external table in my application and I need to make a query where one of the columns has wrong formatting, let's say, the format is alphanumeric without symbols but the column has data with dashes, apostrophes, dots, you name it. Is it possible to just query one of the columns with that filtered out? It'd really help me. I'm using Laravel and I know I can make an accessor to clean that out but the query is heavy. </p>
  
  <p>This is an example:</p>
  
  <p>Data sought: 322211564</p>
  
  <p>Data found: 322'211'564</p>
  
  <p>Also 322-211-564</p>
  
  <p>EDIT: Just to clarify, I don't want to EXCLUDE data, but to "reformat" it without symbols.</p>
  
  <p>EDIT: By the way, if you're curious using Laravel 5.7 apparently you can query the accessor directly if you have the collection already. I'm surprised but it does the trick.</p>