i need to create a filter which retrieves rows with null value like
IPredicateExpression filter = new PredicateExpression(); filter.Add(ItemSubCategoryFields.SubCategoryId is null);
but ofcourse that wouldn't work
filter.Add(ItemSubCategoryFields.SubCategoryId == DBNull.Value);
silly me