Capitalize only the first letter of a name
Another way is to use STUFF to replace the first character directly:

-- Demo
SELECT
    STUFF
    (
        O.name,
        1, 1,
        UPPER(LEFT(O.name, 1))
    )
FROM sys.objects AS O;