Convert the values of a column

Question

Hi,


In SQL server 2008, I have two tables emp1 and emp2, both with columns Name, Lastname, Language. I have to import from table1 to table 2, only that in Table1 the value of Language is 'E', 'S', 'F' and when I import it to Table2 it has to be converted to 'English', 'Spanish, 'French'.

What is the SQL statement for that?



Thanks