Is there an equivalent of the DECODE statement for SQL Server?

In Oracle the following would apply

DECODE(COLUMN_NAME, NULL, 'value', COLUMN_NAME)



MS Sql Server LazyDBA home page