SQL Query

Yup, that's a possibility. Or use the IN clause:

SELECT  GLDV_Alt ,
        CASE WHEN gldv_alt_div_n IN ( '1209', '1120', '1401' ) THEN '1400'
             ELSE 0
        END AS 'Region South'
FROM    gldv;

Select allOpen in new window

The final choice would be to use a lookup table.  The only real advantage of this method is less chance for error if the list of numbers changes and/or becomes more complex, as the query itself doesn't change, just the values loaded into the table.  For a very large gldv table, you might even notice some performance improvement.

CREATE TABLE #GLDV_Div (
    gldv_alt_div_n varchar(4) NOT NULL,
    result varchar(4) NOT NULL
    )
INSERT INTO #GLDV_Div VALUES('1209' , '1400')
INSERT INTO #GLDV_Div VALUES('1120' ,  '1400')
INSERT INTO #GLDV_Div VALUES('1401'  , '1400')


Select GLDV_Alt, isnull(lookup.result, '0') As 'Region South'
from gldv
left outer join #GLDV_Div lookup on lookup.gldv_alt_div_n = gldv.gldv_alt_div_n

isames, do you still need help with this question?