Do not load record with null field

[#1]

How can i adjust my load script to ensure the recorded without an AccountId are NOT loaded

Both these expressions kick up errors. What exactly am I doing wrong?

WHERE NOT IsNull(AccountId);

and

WHERE len(trim(AccountId))>0;

[#2]

Yes, youre right Jonathan. It is

the complete script is

SQL SELECT *

FROM Contact

WHERE RecordTypeId NOT IN ('012w000000063XQ','012w000000063qu') AND AccountId IS NOT NULL;

Apologies Charles and Anbu for not being a little clearer. I should have posted the entire script

However I now get this error error

[anbu1984]

Which database are you connecting to?

[#4]

SalesforceDLL.dll

[anbu1984]

Try

WHERE AccountId = NULL;

[antoniotiman]

Hi Alex,

have You tried with Preceding Load Sintax ?

Like :

Load *

Where Not IsNull(Field);

SQL Select *

From Table;

[#7]

I assume you meant

WHERE NOT AccountId = NULL;

That gives the error

ERROR at Row:2:Column:68 unexpected token: 'NOT'

[anbu1984 · Accepted solution]

For Not Null, try this

WHERE AccountId != NULL;

[#9]

This worked!!!

thanks

[anbu1984]

You can use Not and IsNull()

Where Not(IsNull(AccountId ))

If you are looking for where AccountId is not blank, then use this

Where AccountId != ''

Or

Where Not(IsBlank(AccountId ))