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.

Again no. You will get it.

Let me give example, because you not see good how Index By words do work

Let you have record

    

    group1,group2,group3

Valentina split this on 3 words, and into index go 3 entries:

    group1      1
    group2      1
    group3      1


Now when you do:
    
    SELECT * from T WHERE Article_Newsgroups = 'group1'

Valentina do search in index and it find this word, and result is RecID = 1.

    SELECT * from T WHERE Article_Newsgroups = 'group2'

The same: result is RecID = 1

    SELECT * from T WHERE Article_Newsgroups = 'group3'

Again RecID = 1.


> 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...

-- 
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]