UPPER on mixed case

Question

UPPER on mixed case

Accepted Answer

UPPER converts only alphabetic characters to uppercase. Digits and spaces are unaffected - 123 stays as 123. The result is 'HELLO WORLD 123'. You can use UPPER and LOWER together to implement title-casing, though SQL has no built-in INITCAP in all databases (PostgreSQL does have INITCAP).