: IIF(aa  = 'G', '그래픽', IIF(aa = 'C', '전파', 'SD')) "구분"

그런데 소스가 좀 늘어지네요...
select
  IIF(cd_code = 'G','그래픽',
     IIF(cd_code = 'C','전파',
        IIF(cd_code = 'R','조사',
           IIF(cd_code = 'O','아웃도어',
              IIF(cd_code = 'H','협찬',
                 IIF(cd_code = 'I','인터넷',
                    IIF(cd_code = 'P','P/T','기타'))))))) "구분"
from tr050t

칸을 안 띄어도 되는데... 가독성 문제도 있고...쩝...

select
   case when cd_code = 'G' then '그래픽'
            when cd_code = 'C' then '전파'
            when cd_code = 'R' then '조사'
            when cd_code = 'O' then '아웃도어'
            when cd_code = 'H' then '협찬'
            when cd_code = 'I' then '인터넷'
            when cd_code = 'P' then 'P/T'
            else '기타'
   end "구분"
from tr050t

case문법이 더 좋을라나요?