Declare @FirstChatCapital nvarchar(20)
Set @FirstChatCapital = 'codeproject'
Select upper(substring(@FirstChatCapital,1,1))+lower(substring(@FirstChatCapital,2,len(@FirstChatCapital)))
You can replace your table column name with @FirstChatCapital variable.