case when then...else end sql Óï¾äÓ÷¨

select f.AGENTID as 'ID',
          f.AGENTNAME as 'ÐÕÃû',
          f.COMNAME as '¹«Ë¾¼ò³Æ',
          c.REGISTDATE as '×¢²áʱ¼ä',
          c.VALIDDATE as '½ØÖÁʱ¼ä',
          c.DISTRICT as 'ÇøÏØ',
          c.COMAREA as '¸ºÔðÇøÓò',
          c.category as 'µÈ¼¶',
         case when  c.agentcardflag = 1 then '´ýÉóºË'
                 when c.agentcardflag = 2 then 'ÉóºËͨ¹ý'
                 when c.agentcardflag = 3 then 'δͨ¹ý'
                 else 'δͨ¹ý'
                 end as 'Éí·ÝÉóºË״̬'
from  MagentInf f ,MagentCon c where c.AGENTID = f.AGENTID and c.Ispay = 0
ÏÂÃæΪתÔØ
SELECT
CASE WHEN USERID=10 THEN 'ÉçÇøÓû§£º'+SELECT NAME from(SELECT NAME from USER_INFO UI WHERE UI.[ID]=A.USERID)
    WHEN USERID=20 THEN '×¢²áÓû§£º'+SELECT NAME from(SELECT NAME from REGISTER_INFO UI WHERE UI.[ID]=A.USERID)
    WHEN UERID=30 THEN 'ÆÕͨÓû§£º'+SELECT NAME from(SELECT NAME from SIMPLE_INFO UI WHERE UI.[ID]=A.USERID)
    --.....»¹Óкü¸¸öWHEN
    ELSE '' END,
    A.TITLE,A.TETENT
from BASICINFO A