Sql-server – Full text catalog/index search for %book%

full-text-searchsql serversql-server-2005wildcard

I'm trying to wrap my head around how to search for something that appears in the middle of a word / expression – something like searching for "LIKE %book% " – but in SQL Server (2005) full text catalog.

How can I do that? It almost appears as if both CONTAINS and FREETEXT really don't support wildcard at the beginning of a search expression – can that really be?

I would have imagined that FREETEXT(*, "book") would find anything with "book" inside, including "rebooked" or something like that.

Best Answer

unfortunately CONTAINS only supports prefix wildcards:

CONTAINS(*, '"book*"')