First, are you using SQL Server 2012 or SQL Server 2005? You have double posted in two different forums.

Second, please don't double post, it fragments answers you may get.

Third, you want to convert the DECODE to a CASE clause.