Jimmy Underwood

Jimmy Underwood

  • NA
  • 118
  • 82.8k

Convert the values of a column

Feb 29 2012 12:16 AM
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

Answers (2)