It could help STARTING WITH .... but this check just the beginning of ...

Regards,
Paul

> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] On Behalf Of "Szabó Sándor (Süni)"
> Sent: Friday, September 12, 2008 9:33 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Index question
>
> 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 :-)
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>