title: SQL: creating a string array and query = like all strings in array
body: <p>I have SQL Server 2005 Report that takes a parameter in a query string that searches customer names. The problem is some customers like to put in a middle initial so when the user 'John Smith' this does not bring up 'John Q. Smith'.</p>
  
  <p>Using only sql, how would I split a string into an array by whitespace then search records matching each string in the array to the result?</p>