Re: Exact phrase searches on FTS

Tech-Archive recommends: Speed Up your PC by fixing your registry

Jose wrote on Mon, 17 Jul 2006 10:33:16 +0200:


Hi,

Does anybody knows how to create a T-SQL using CONTAINSTABLE from which
brings an exact phrase results?

At the moment I get the same results if I look for "Yellow*" and
"Yellow"... is a bit weird.

That would imply that you have no rows with words starting with Yellow, such
as Yellowing. If you don't, then seeing the same results is expected - it's
matching on all rows that have the word Yellow somewhere in the text.

Dan


.