Hi.

There is no way to avoid FTS.
Try RedSoft's Firebird branch. It supports Lucene engine using JavaVM
interfaces.

http://www.red-soft.biz/en/index.html

Though I have not tried it myself yet.

Or you can try to create your own FTS, like writing a UDF that splits
your varchar into words and stem them. Then you can create additional
talbe of all stemmed words and N:N link table with your main. Then you
would need FTS query engine etc...

Maxim.

--- In firebird-support@yahoogroups.com, "Szabó Sándor (Süni)"
<basswar@...> wrote:

>
> Hi all!
>
> Is there any solution for fast searching against textual data in a
> VARCHAR typed column? The search should find any matching pattern in

the

> mentioned column. I know CONTAINING doesn't use any indexes, so is

there

> any other solution? There are many records and the search should be

fast

> enough. I tried XFTS, but it didn't proved its power to me.
>
> TIA:Alex :-)
>