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: