HOW TO USE CASE IN SQL SERVER 2005

Below is syntax to use CASE in SQL Server 2005

Syntax:
SELECT
CASE
    WHEN CONDITION THEN
            DATA                  
        ELSE
            DATA
    END AS column_name
FROM tableName

Example:
SELECT
CASE
        WHEN SIGN(DATEDIFF(dd,GETDATE(),any_date)) = '1' THEN
            DATEDIFF(dd,GETDATE(),any_date)                  
        ELSE
            SIGN(0)
    END AS column_name
FROM any_table 

Note : You can use number of WHEN condition before ELSE