SQL to count how many records have lower case name
Posted on 2013-01-31
I have a table that is populated by a form that a user can enter in one of two ways. The first way is when the user pastes the data from another system. When done this way (which is the preferred way), the data goes into the columns in upper case. The other way is for the user to manually enter the data and when this happens the data usually appears in lower case.
What I am looking for is a query that will count how many records where the LastName column contains lower case letters.
Can anyone help me with this?