Looks like SQL FTS doesn't allow wildcards at the beginning of a search term. I ran into this a few days ago while trying to get FTS to work for a project, didn't understand why it wasn't working, but here is the answer from Microsoft(R) SQL Server 2005 Unleashed:
"However, SQL Server FTS does not allow a wildcard at the beginning of a word; for these types of prefix-based searches, you still have to use a LIKE clause."Knowing this 4 days ago would have been extremely beneficial.
No comments:
Post a Comment