DECLARE @theCountry VARCHAR(7)
SET @theCountry = 'Caca'
INSERT INTO TABLE VALUES (
'0000',(
CASE
    WHEN (@theCountry = 'Spain') THEN 'ES'
    WHEN (@theCountry = 'Caca') THEN 'KK'
END)
,'00000000','',''
)