SQL - Find Records with Specific Case Letters , Alphabets or Numerals in a field

1. Find records with all lower case alpha numeric characters in a field

Select * from Table_Name where Column_Name=lower(Column_Name)

2. Find records with all upper case alpha numeric characters in a field

Select * from Table_Name where Column_Name=upper(Column_Name)

3. Find records with any lower case alpha numeric characters in a field

Select * from Table_Name where Column_Name != upper(Column_Name)

4. Find records with any upper case alpha numeric characters in a field

Select * from Table_Name where Column_Name != lower(Column_Name) 

5. Find records with all numeric characters in a field

Select * from Table_Name where isnumeric(Column_Name) = 1

6. Find records with alphabets characters in a field

Select * from Table_Name where where isnumeric(Column_Name) != 1