DECLARE @T Table(Name Varchar(20))
INSERT INTO @T
SELECT 'karurkit' UNION ALL
SELECT 'ranjha' UNION ALL
SELECT 'sebanintian'
SELECT
OriginalName =Name
,ModifiedName=CONCAT(UPPER(LEFT(Name,1)),SUBSTRING(NAME, 2, LEN(Name)-2),UPPER(RIGHT(NAME,1)))
FROM @T
Output
--------- OriginalName ModifiedName
karurkit KarurkiT
ranjha RanjhA
sebanintian SebanintiaN