title: Get rid of non-digits and then get last n chars of a string in LINQ
body: <p>I have two tables, both of them with a <strong>Phone</strong> column.</p>
  
  <p>This column -NVARCHAR(30)- can have its stored data formatted in several different ways, from <strong>0001 222 333 444</strong> to <strong>222 333 444</strong> to <strong>(0001)-222333444</strong> to <strong>-</strong> to even an empty string. </p>
  
  <p>I would like to do a query using LINQ where the first three examples shown above would give a match, so I need to get rid of everything that's not a number and then get the last 9 digits out of the string. However, I haven't been able to do this using just one query, and instead I'm looping through each of my results and apply the phone number filters there. Any way this could be done with just the query?</p>