Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you provide any sample data.
Please use this
Load * where (Not isnull(B) and IsNull(C)) or (isnull(B) and not isnull(C));
Example attached
Thanks
AJ
Better way:
Load * where Isnull(B) xor Isnull(C);
Thanks Ajay, XOR works perfectly for me. Cheers...!!!