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 · Accepted solution]

WHERE (DOINVSTATUSID IS NOT NULL OR DOINVSTATUSID NOT LIKE  ';%')

Should work fine?

However you might find it isn't actually null but blank?

In which Case

WHERE (LEN(DOINVSTATUSID) >0 OR DOINVSTATUSID NOT LIKE  ';%')

[#3]

Thank you Adam!

[kaushiknsolanki]

Try below script,

I havent tested, but I guess this should work.

Sql Select * from Xyz where not isnull XYz;

Regards,

Kaushik Solanki

[adamdavi3s]

No worries which was the correct one in the end?? purely for my own interest!

[#6]

WHERE (DOINVSTATUSID IS NOT NULL OR DOINVSTATUSID NOT LIKE  ';%')

[#7]

Adam it turns out that that wasn't right...

[adamdavi3s]

Not a problem, we are here to help!

Can you look at the data in SQL Management studio and if so what does it look like?

[#9]

[Anil_Babu_Samineni]

Try like this

Load

     *

     FROM

     <Table-Name>

          Where

                    Len(DOINVSTATUSID)>0

                              Or

                    not WildMatch(DOINVSTATUSID,'*;**');