"Raj Gandhi" <Raj Gandhi@discussions.microsoft.com> wrote in message
news:5D575288-ADDD-426C-B230-03CE8AFDCC84@microsoft.com...
>I am a software developer and working on one of the client application
>where
> Full text search is required.
>
> Requirement:
> The search should allow to use whild cards.....
>
> Problem:
> the full text search does not work for postfix terms.....
>
> I have three rows in my table
> 1. Marketing
> 2. Mark
> 3. Remark
>
> When I search "Mark*" it will return me
>
> Mark and Marketing but not Remark
>
> When I search using "*Mark*" it will return the same result
>
> I am expecting that all rows should come but unfortunately I am getting
> same
> result.
>
> I am not sure where I am making mistake. I appreciate your time and effort
> to help me.
>
> e.g. if user specifies 'Mark' as keyword the search should match 'Mark',
> 'Marketing' and 'Landmark'.... right now the CONTAINS clause ignores the
> 'LandMark'
>
> Thank you
>
>

> I am a software developer and working on one of the client application
> where Full text search is required.
>
> Requirement:
> The search should allow to use whild cards.....
> Problem:
> the full text search does not work for postfix terms.....
> I have three rows in my table
> 1. Marketing
> 2. Mark
> 3. Remark
> When I search "Mark*" it will return me
>
> Mark and Marketing but not Remark
>
> When I search using "*Mark*" it will return the same result
>
> I am expecting that all rows should come but unfortunately I am
> getting same result.
>
> I am not sure where I am making mistake. I appreciate your time and
> effort to help me.
>
> e.g. if user specifies 'Mark' as keyword the search should match
> 'Mark', 'Marketing' and 'Landmark'.... right now the CONTAINS clause
> ignores the 'LandMark'
>
> Thank you
>