FAQ: How can I perform wildcard searches in Full-Text Search?
I want to do a wildcard search using Full-Text Search. For example, I want to know the books that have "Chain" in their names.
When using the CONTAINS predicate in Full-Text Search, you can enclose the search condition (word or phrase) in double quotation marks ("") and add an asterisk (*) before the ending quotation mark.
WHERE CONTAINS(BookTitile,' "Chain*" ')
By this way, all records have a match of words or phrases beginning with "Chain" will be returned.
However, if you specify "*Chain" or "Ch*ain", you will not get the expected result. The asterisk will be considered as a normal punctuation mark not a wildcard character.
SQL Server 2005
SQL Server 2008
SQL Server 2008 R2