Excel PROPER — no T-SQL twin

PROPER is a spreadsheet luxury. T-SQL will not title-case a name for you in one function.

-- Honest version: clean in the app, or
UPPER(LEFT(first_name, 1)) + LOWER(SUBSTRING(first_name, 2, 200))
-- misses McDonald and hyphenated names

Do not ship a 40-line scalar function for names. Fix the load.

Canonical translation

-- Honest version: clean in the app, or
UPPER(LEFT(first_name, 1)) + LOWER(SUBSTRING(first_name, 2, 200))
-- misses McDonald and hyphenated names