How to make Upper first CHAR Word

UPDATE [TableName]
SET = UPPER(LEFT(LOWER(), 1)) + SUBSTRING(LOWER(), 2, LEN())