Ways of getting First Characters Capitalize in Sql Server.

select Upper(SUBSTRING('vishal', 1, 1)) as First_Character_Capatalize

select Upper(LEFT('vishal', 1)) as First_Character_Capatalize