• Sql Server syntax for updating using a case statement:

    update table_1

    set Datum2=(case when datum1='1' then 'One'

    when datum1='2' then 'two'

    when datum1='3' then 'three'

    else 'four' end)