• what I understand with ur prob is that you can write CAsE statement in this manner-

    SELECT

    Case when 1=1 THEN 'Yes' ELSE 'No' END

    WHERE 1 IS NOT NULL

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/