update column 1st letter

Could you try below? Please paste error message what you get.

UPDATE Stud_Master
SET first_name = upper(LEFT(RTRIM(ltrim(first_name)), 1)) + lower(SUBSTRING(first_name, 2, LEN(first_name)))

---

-Vaibhav Chaudhari