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. |
||