Sorry, but according to the full text indexing rules ( does not exist. So "Jaw Pain" and "jaw (pain" are exactly the same to the full text engine. Also, notice that the SQL Server full text indexing does not recognize different
sentences and so forth.
If this is a problem use the Contains query to produce a derived table, then add a Like search to find the exact string.
Declare @str varchar(100)
set @str=' "Jaw pain" '
FROM (select KeyColumn, tblColumn from yourtable where contains(tblColumn,@str)) AS FTSearch
WHERE FTSearch.tblColumn LIKE '%'+@str+'%'
The full text will be faster than scanning all the strings (normally) then the LIKE will filter down to what you want.
편집됨SQLWorkMVP2012년 7월 5일 목요일 오후 7:28corrected code