title: Using SELECT to obtain only fields with alphanumeric data (and certain punctuation) in SQL Server
body: <p>I am trying to filter some SQL server data and require results with the following conditions:</p>
  
  <ul>
  <li>where the field has alphanumeric characters, case insensitive</li>
  <li>where the field has certain punctuation (apostrophe and hyphen)</li>
  <li>where the field has no spaces</li>
  </ul>
  
  <p>Is there an efficient way to do this using CHAR in SQL Server or does anybody have a better solution?</p>