>Chris,
>
>Try

SELECT OrderID FROM Orders ;
>  WHERE (vp_ItemID < 0 AND  Orders.OrderID NOT IN ;
>           (SELECT OrderID FROM LineItems ;
>               WHERE LineItems.ItemID = ABS(?vp_ItemID)))  ;
>	OR ;
>  	(vp_ItemID >= 0 AND Orders.OrderID IN ;
>           (SELECT OrderID FROM LineItems ;
>    	     WHERE LineItems.ItemID = ?vp_ItemID))
>

Thanks. After a little shoehorning, it worked. Any ideas why the other version C5'ed?

Chris.