title: How to find values in all caps in SQL Server?
body: <p>How can I find column values that are in all caps? Like <code>LastName = 'SMITH'</code> instead of <code>'Smith'</code></p>
  
  <p>Here is what I was trying...</p>
  
  <pre><code>SELECT *
    FROM MyTable
   WHERE FirstName = UPPER(FirstName)
  </code></pre>