곰탱이의 개인블로그

DECLARE @CODE_NO INT

SET @CODE_NO = 3

SELECT

        CASE @CODE_NO

               WHEN 1 THEN '서울'

               WHEN 2 THEN '대전'

               WHEN 3 THEN '대구'

               WHEN 4 THEN '부산'

               WHEN 5 THEN '광주'

               ELSE 'NO DATA'

        END AS 'AREA'

DECLARE @CODE_NO INT

SET @CODE_NO = 3

SELECT

        ISNULL(CHOOSE(@CODE_NO, '서울', '대전', '대구', '부산', '광주'),'NO_DATA')  AS 'AREA'