title: Ignore All Spaces when using DataTable.Select()
body: <p>I need to select from a datatable based on a phone number.  The problem is that the phone number may have spaces in it, but these aren't necessarily consistent.</p>
  
  <p>For example a phone number in the datatable could be any of the following -</p>
  
  <p>01234 123 123<br />
  01234 123123<br />
  01234123123<br />
  0123 412 3123<br />
  0123 4123 123</p>
  
  <p>Which is actually all the same number.</p>
  
  <p>I can standardize the search string and remove spaces from that, but how can I make a search for "01234123123" match the column that actually contains "0123 412 3123" or any other variant?</p>
  
  <p><code>DataTable.Select("phoneNumber LIKE '" + searchString + "%'")</code></p>
  
  <p>Will only return the row if the number matches exactly.</p>
  
  <p>I have thought of looping through and generating many variations of the searchString with spaces in all the possible places and then searching for all of them but that seems very resource intensive...</p>
  
  <p>Is there a better way?</p>