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
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