> we want to use the full text searching to find data in three fields in one
> step. Two of the fields are varchar(40) and one field is a Blob. What we
> find out, is that it is only possible to search in one field. If this is
> right, we must do a copy of this three fields in one Blob. If we do that we
> have lot of redundant data. We think that this is not the right way. Have
> you any ideas for us.

You can create a calculated field on the server, i.e.

ALTER TABLE MYTABLE
ADD DESCRIPTION_FTS COMPUTED BY ( DESCRIPTION1 || ' ' || DESCRIPTION2 )

But I don't know, if this works with a text blob...

--
Marco Krause