Hi David,

Thanks, that will do what I'm after with a bit of fiddling.

Tom

In article <GNKdnYq-FZS3MTKi4p2dnA@giganews.com>,
REMOVE_BEFORE_REPLYING_dportas@acm.org says...
> SELECT *
> FROM territories
> WHERE regionid = 1
> OR (regionid = 2 AND @both = 1)
>
>