I don't know but try isNull(table.field,'').