>Hi,
>I'd create a 'FilterCondition' class containing a string collection (one for each 'individual' filter condition) and a BuildFilter() method that concatenated them all together when needed. The method to add individual conditions to the collection would just need to check the existing collection and only add conditions that were not already there. An additional benefit would be that it would be simpler to remove individual conditions.
>
>Regards,
>Viv

Good idea.

But I don't understand why

myField = 'MyValue' AND myField = 'MyValue' can fail even if the same condition would be repeated twice.