Using Full-Text-Search in order to find partial words (SQL Server 2008)

sql-server sql-server-2008 full-text-search
DiGMi picture DiGMi · Jun 3, 2010 · Viewed 16.5k times · Source

I'm trying to build a facebook like search for my software.

I'd like to query the table customers.

I've set up a FULLTEXT Index and tried the next query

SELECT * FROM Customer where CONTAINS(*,'*ann*')

The query does return all the customers named Ann, but it doesn't return all the customers name Anne.

Is there a way to create prefix search on SQL Server 2008 using FTS?

Answer

DiGMi picture DiGMi · Jun 7, 2010

I've found a solution to my problem. The query should be:

select * from Customers where contains(*, '"ann*"')

The quotes are the important part.

Related questions

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed

I am getting following error in my SQL server 2008 R2 database: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblArmy' because it is not full-text indexed.

Read More
SQL Fuzzy Matching

Hope i am not repeating this question. I did some search here and google before posting here. I am running a eStore with SQL Server 2008R2 with Full Text enabled. My requirements, There is a Product Table, which has product …

Read More
Why the Full-Text indexing option is greyed out?

I installed SQL Server 2008 Express with Advanced Services, but when I try to create a new database, the option Full-Text indexing is greyed out, I believe the full-text indexing has been installed, because I did a query as below: use […

Read More