In order to search part of words using CONTAINS command add * in the start and/or the end of the search Phrase:
select * from TABLE WHERE CONTAINS(Field4Search, N'"*copy pas*"')
If you have a parameter, you need to add those 2 *:
(N'"*' + @TxtValue + N'*"')
The table should be enabled "Full-Text" search the only we can use this command!
ReplyDelete