Is this the right way to exclude rows with NULL values from the LABKEY.ext.Store ?

LabKey Support Forum (Inactive)
Is this the right way to exclude rows with NULL values from the LABKEY.ext.Store ? Ben Bimber  2012-05-14 19:57
Status: Closed
 
hi leo,

this is difficult to answer without seeing your data, but postgres will treat empty strings differently than null. could you try:

WHERE <curElemMod> != ''

and see if this excludes the records you expect? if this is true, as a general rule i would recommend converting empty strings to null as these sort of problems will creep in.