HOW TO CHECK IF STRING CONTAINS LOWER CASE LETTER OR UPPER CASE LETTER USING T-SQL

Use the below SQL query:-

select distinct laboratories_Clean from CLEAN.Product_Ref

where laboratories_Clean != UPPER(laboratories_Clean) collate Latin1_General_CS_AI