title: Oracle Decode function equivalent in Sql Server 2005+
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1559241/decode-function-in-sql-server">DECODE( ) function in SQL Server</a>  </p>
  </blockquote>
  
  
  
  <p>Is there a direct equivalent of <a href="http://psoug.org/definition/DECOMPOSE.htm" rel="nofollow noreferrer">Oracles Decode</a> function in SQL Server (2005 or later)?</p>
  
  <p>If not, is there another way of accomplishing the same effects as DECODE?</p>