SQL Case Sensitive String Compare

The Standard approach is to use a case-insensitive collation, though the collations themselves are vendor-specific.

SELECT *
FROM ABSTRACT
WHERE ABSTRACT_TYPE <> UPPER(ABSTRACT_TYPE) COLLATE Latin1_General_CS_AS