Wild Card Search

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sathian - 30 Aug 2005 12:37 GMT

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.

Thanks in anticipation

Sathian

Reply to this Message

Daniel Crichton - 30 Aug 2005 12:43 GMT

Sathian wrote on Tue, 30 Aug 2005 17:07:07 +0530:

> Hello All,
>
[quoted text clipped - 6 lines]
> 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

Reply to this Message

Hilary Cotter - 30 Aug 2005 15:45 GMT

You can also use the Thesaurus option in SQL 2005 (supported) and SQL 2000
(unsupported) to expand searches on plan to search on testplan as well as
plan. This will work if you know in advance all the prefixes you wish to
search for.

Check this link out for more info:

http://www.indexserverfaq.com/sqlthesaurus.htm

Signature

Hilary Cotter
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

> Sathian wrote on Tue, 30 Aug 2005 17:07:07 +0530:
>
[quoted text clipped - 18 lines]
>
> Dan

Reply to this Message