title: Test for Upper Case - T-Sql
body: <p>All,</p>
  
  <p>How can I check if a specified varchar character or entire string is upper case in T-Sql? Ideally I'd like to write a function to test if a character is upper case, then I can later apply that to a generic varchar. It should return false for non alphabetic characters. I am only interested in english language characters.</p>
  
  <p>I am working with T-sql in SQL Management Studio, and I have tried pulling records beginning with a lower case letter from a table in this fashion:</p>
  
  <pre><code>select * from TABLE
  where SUBSTRING(author,1,1) != LOWER(SUBSTRING(author,1,1))
  </code></pre>
  
  <p>Which returns 0 records, but I know there are records beginning with upper and lower case letters.</p>
  
  <p>Thanks</p>
  
  <hr>
  
  <p><b>EDIT:</b> Since both <a href="https://stackoverflow.com/users/1453411/podiluska">podiluska</a> and <a href="https://stackoverflow.com/users/477878/joachim-isaksson">joachim-isaksoon</a> have successfully answered my question (Both methods work for my purposes), would someone mind explaining which would be the most efficient method to use to query a table with a large number of records to filter out records with authors beginning with or without a capital letter?</p>