"Daniel Crichton" <msnews@worldofspack.co.uk> wrote in message
news:ORSZUgVrFHA.2008@TK2MSFTNGP10.phx.gbl...
> Sathian wrote on Tue, 30 Aug 2005 17:07:07 +0530:
>
> > Hello All,
> >
> > We implement the wild card search using 'Contains' in full Text Search.
> > However the search with the word portion within the word could not be
> > achieved
> > In otherwords if I seach with the key word 'plan' the test result should
> > include the record having the word 'Testplan'.
> > Is this possible in Full Text Search? (Currently if we search for 'test'
> > it gives the result with the word 'Testplan'.)
> > Please give us an idea, if possible.
>
> FTS allows searching on the start of words only (eg. plan* will find all
> words that start with plan, or where the entire word is plan), not parts
in
> the middle or at the end. You will need to revert to using LIKE against
the
> column to do this, or if you only want to look for the ends of words and
> require FTS then duplicate the column in reverse order and add to your FTS
> catalog (so for each row you have 2 columns that are indexed, one being
the
> original data, one being the same data in reverse character order).
>
> Dan
>
>

> Hello All,
>
> We implement the wild card search using 'Contains' in full Text Search.
> However the search with the word portion within the word could not be
> achieved
> In otherwords if I seach with the key word 'plan' the test result should
> include the record having the word 'Testplan'.
> Is this possible in Full Text Search? (Currently if we search for 'test'
> it gives the result with the word 'Testplan'.)
> Please give us an idea, if possible.