Help query null/not null return 0/1 - Lars

table A
Col1 char(4)
Col2 char(6)
INSERT INTO A('1', 'ABC')
INSERT INTO A('2', 'XYZ')

Table B
Col1 char(4)
Col2 char(6)
INSERT INTO B('1','ABC')

SELECT a.Col1, a.Col2, b.Col2
FROM A
LEFT JOIN B ON a.Col1=b.Col1

I want the result to be:

1, ABC, 1
2, XYZ, 0

I need the b.Col2 to be zero when the value is null, otherwise 1.

Thanks, Lars

Help query null/not null return 0/1 - Plamen Ratchev

You can use the CASE function:

SELECT A.Col1, A.Col2,
CASE WHEN B.Col2 IS NULL
THEN 0
ELSE 1
END
FROM A
LEFT JOIN B
ON A.Col1 = B.Col1;

--
Plamen Ratchev
http://www.SQLStudio.com