Such search cannot be optimized by full-text or any other indexes and will require full table scan. You may use regular
LIKE '%iche%'.
>I have enabled the full text indexing on a field on a specific table. I have found that this is based on word recognition. Thus, anything that is separated by a space or a dash, for exemple, would be considered a word. So, assuming I have this:
>
>
>SELECT Client.Name FROM Client WHERE Contains (Name, '"Michel*"')
>
>
>this will return all records having a word starting with Michel in the Name field. So, the following would be found:
>
>Michel Fournier
>Michel Something
>The name is Michel
>The name is Michel2 something
>
>This is good and the result is immediate.
>
>However, Contains will search for a word starting with Michel. What if I need to search for 'iche'? As I have no word starting with 'iche', none of the following field values will be found.
--sb--