AND OR CONDITIONS

[ankit777]

hi All,

I have a table with three columns A,B,C.

There are null values in B and C.

I want to create another table from the above table where either B is null or C is null.

I dont want to include records where both B & C are nul or not null. I want records for which either B is null or c is Null.

Plz Help.

[its_anandrjs]

Can you provide any sample data.

[#3]

Please use this

Load * where (Not isnull(B) and IsNull(C)) or (isnull(B) and not isnull(C));

Example attached

Thanks

AJ

[#4 · Accepted solution]

Better way:

Load * where Isnull(B) xor Isnull(C);

[ankit777]

Thanks Ajay, XOR works perfectly for me. Cheers...!!!