title: SQL Server 2016 How to use a simple Regular Expression in T-SQL?
body: <p>I have a column with the name of a person in the following format: "LAST NAME, FIRST NAME"</p>
  
  <ul>
  <li>Only Upper Cases Allowed</li>
  <li>Space after comma optional</li>
  </ul>
  
  <p>I would like to use a regular expression like: [A-Z]+,[ ]?[A-Z]+ but I do not know how to do this in T-SQL. In Oracle, I would use REGEXP_LIKE, is there something similar for SQL Server 2016?</p>
  
  <p>I need something like the following:</p>
  
  <pre><code>UPDATE table 
  SET is_correct_format = 'YES'
  WHERE REGEXP_LIKE(table.name,'[A-Z]+,[ ]?[A-Z]+');
  </code></pre>