How do I pull in all rows except for ones with a null value?

[#1]

Maybe this is best suited for a SQL discussion but here goes.

I want to pull in all rows except for the ones where DOINVSTATUSID is not equal to NULL.

I tried WHERE DOINVSTATUSID <> ';'. ITMSNumber NOT LIKE '_%'; (because I don't want the ones with a character at the front), DOINVSTATUSID IS NOT NULL;

None of them work.

[adamdavi3s]

So its correct in SSMS but Qlik is pulling in invalid rows?!

[#3]

You're probably right Adam... I think there is something else going on here. I'll have to start a new discussion.

[adamdavi3s]

No worries, feel free to tag me in it and I will take a look

[#5]

Hi plz check the attached doc, i hope it will help you

[#6]

I can't open it.... I have personal edition I believe, even though I'm working for a conglomerate.