Blog Pages

Search part of words using CONTAINS command

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'*"')

1 comment:

  1. The table should be enabled "Full-Text" search the only we can use this command!

    ReplyDelete