Where SQL statement for Not Null Field (Memo type)

[flor]

I want to set a condition for a selection where Refer field which is of Memo type is not null...

SELECT Address.org_code, Address.post,;
Address.org_name, Address.refer FROM Address;
WHERE Address.refer IS NOT NULL;
ORDER BY Address.org_code

but seems it doesn't work

flora

 

[Mike Gagnon]

I don't the value NULL applies to a memo.

SELECT Address.org_code, Address.post,; 
Address.org_name, Address.refer FROM Address;
WHERE !EMPTY(Address.refer);
ORDER BY Address.org_code

 

[flor]

i got it.
thanks