title: Regex in SQL Server to check whitespaces
body: <p>I am checking for invalid names(names with special characters) in SQL Server with the following code</p>
  
  <pre><code>select First_Name 
  from sc.Name 
  where First_Name LIKE '%[^a-zA-Z]%';
  </code></pre>
  
  <p>How to add the check for leading and trailing whitespaces?</p>