Update each row in a table with existing values but capitalized
===

I have a table that has the following structure

    LanguageName    |Code 
    ----------------|----
    Abkhaz  	    |ab
    Afar  	        |aa
    Afrikaans  	    |af
    Akan  	        |ak

I have about 190 similar rows.

And, 

> I need to update each row as Capitalizing the first letter of the
> Column Code for each row.

So, that the result would be: 


    LanguageName    |Code 
    ----------------|----
    Abkhaz  	    |Ab
    Afar  	        |Aa
    Afrikaans  	    |Af
    Akan  	        |Ak



How can I achieve this in SQL-Server?