Not directly. This is a design constraint of all RBDMS's.

The mechanism to accomplish this goal in an RDBMS is to parse out
keywords into their own table, with foreign keys and (optional) offsets
back to the main text table.

Good luck.

On Wed, 2005-08-31 at 12:01 +0000, m_formigoni wrote:
> Hi,
>
> I'm using the "containing" keyword in a select and can see it doesn't
> uses the index for the column, is it normal? If yes, is there another
> way to use the index in this case (search a text in any position of a
> varchar column)?
>
> Tks.
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>