hello all,

got 2 tables - and I've posted on these before - GraphicObjects & PropertyValuesForGraphics - each Graphic has many Properties. I want to do this sql statement:

select graphicobject_id from graphicobject where graphicobject_id not in (select graphicobject_id from propertyvaluesforGraphic where Property_Name = 'SourceField.Property')

unfortunately most search engines consider both not and in words to not search for

I think I'm being dense on this one - any help appreciated. Thanks, Brian

Hmmm... Good question considering the SetOperator enum doesn't have a NotIn value.

Perhaps you just have to use IN and inverse your expression.

BOb

Pass 'true' for the negate parameter in one of the constructor overloads. This is the method used in all predicates.