Hi All,

Does anyone have experience of the above and can offer some tips?

Especially with regard to extracting results using bracketed keywords
and phrases (nothing more fancy is required currently, but I have
found mapping this query to SQL to be much more challenging than first
appears):

("TRAINEE POLICEMAN" OR "TEAM LEADER") AND
(MONETARY OR INSURANCE AND "PRIVATE BANK")

I've got a certain amount working with one of the key tables
documented below:

CREATE TABLE DOCUMENTwORD
(
DOCID INTEGER NOT NULL,
WORDID INTEGER NOT NULL,
WORDNO SMALLINT DEFAULT 0 NOT NULL,
LINENO SMALLINT DEFAULT 0 NOT NULL,
);

The wordno column is used in locating phrases.

For the sake of storing the lineno it allows for the
recreation of a plain text version of the document.

Is FB the best db for this type of task (250,000+ documents). The full
text features of some other db's didn't quite give me what I was after.

Any thoughts certainly appreciated.
Tom