Using Full-Text-Search in order to find partial words (SQL SERVER 2008)
Posted
by dig
on Stack Overflow
See other posts from Stack Overflow
or by dig
Published on 2010-06-03T01:20:31Z
Indexed on
2010/06/03
1:24 UTC
Read the original article
Hit count: 346
Hello,
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?
Thanks.
© Stack Overflow or respective owner
