Stan, I have found interesting solution for you.

[Ruslan Zasukhin]

On 7/16/06 10:54 PM, "Stan Busk" <maxprog at mac.com> wrote:

> Hi,
> 
> Actually I can't do that because of how Usenet works. It is all about
> cross-posting. That is, an article can be posted to as many groups as
> the sender wish. As a result, the 'Article_Newsgroups' field can
> contain 1, 2, 5 , 10 newsgroups and sometimes much more. If I search
> newsgroups like Article_Newsgroups = 'alt.comp.shareware' I will only
> get article that was posted to that one only group and will not get
> all the articles posted to 'alt.comp.shareware' between others. This
> is the reason why the 'Article_Newsgroups' field is a list and as I
> don't know how many groups it will contain I can't split it into
> several fields...

NO.

It works correctly! Just try query as I show.
Both queries give THE SAME result!

Again this effect comes because you have INDEX BY WORD.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]