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