Full-text search

I am working as a sr. Developer for one of the application.
The search should allow to use whild cards....
Consider that I have three rows in table
1. Mark
2. Marketing
3. LandMark
When I search using contains and "Mark*" phrase it will return
Mark and Marketing
When I search using contains and "*Mark*" phrase I expect it to return all
rows but I am getting the same result as "Mark*"
It seems that
full text search does not work for postfix terms....
e.g. if user specifies 'Mark' as keyword the search should match 'Mark',
'Marketing' and 'Landmark'... right now the CONTAINS clause ignores the
'LandMark'
The leading * is thrown away in a search, the trailing on is treated as wild
card character.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Raj Gandhi" <RajGandhi@.discussions.microsoft.com> wrote in message
news:D0334F24-F6F3-4909-A327-9E212D8AE376@.microsoft.com...
>I am working as a sr. Developer for one of the application.
> The search should allow to use whild cards....
> Consider that I have three rows in table
> 1. Mark
> 2. Marketing
> 3. LandMark
> When I search using contains and "Mark*" phrase it will return
> Mark and Marketing
> When I search using contains and "*Mark*" phrase I expect it to return all
> rows but I am getting the same result as "Mark*"
> It seems that
> full text search does not work for postfix terms....
> e.g. if user specifies 'Mark' as keyword the search should match 'Mark',
> 'Marketing' and 'Landmark'... right now the CONTAINS clause ignores the
> 'LandMark'