On Tue, 19 Oct 2004 06:40:07 -0000, Svein Erling Tysvær
<svein.erling.tysvaer@...> wrote:

>
>> What about this?
>>
>> WHERE 1=1 OR FieldA =:ANY
>
> 1=1 will always be true, so every record will be returned regardless
> of whether FieldA = :ANY or not.

The "real" statement is:

WHERE 1=:ACTIVE_FILTER OR FieldA =:ANY

where :ACTIVE_FILTER is 0 or 1.

--
Miroslav Penchev