title: Query for unconventional people names in SQL Server
body: <p>I want to search for the people in a table (10 mil records +) with an unusual names with special characters such as some following samples:</p>
  
  <pre><code>Subject_Name (lastname, firstname):
  *S-luis-Hernandez, Franciscos 
  +, Zeferino 
  -, Jose Antonios
  ., . 
  ., . .
  /, Celsos
  17, Herbert Baltazar
  `, Irving 
  </code></pre>
  
  <p>I can filter the Subject_Name using like % but that's a lot of likes in the query. Is there a better way to pull those records from a large table? </p>