upper in sql stack overflow

select
    UPPER(SUBSTRING(name, 1, 1)) + SUBSTRING(name, 2, LEN(name)),
    UPPER(SUBSTRING(surname, 1, 1)) + SUBSTRING(surname, 2, LEN(surname))
from client;