sql server - Full text catalog/index search for %book%

Question

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.

Answer 1

unfortunately CONTAINS only supports prefix wildcards:

CONTAINS(*, '"book*"')