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

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?

Answers


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

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

The quotes are the important part.


Need Your Help

How do I format a Microsoft JSON date?

jquery asp.net ajax json

I'm taking my first crack at Ajax with jQuery. I'm getting my data onto my page, but I'm having some trouble with the JSON data that is returned for Date data types. Basically, I'm getting a string...