Re: '%phrase%' search

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

Hilary wrote on Mon, 22 Oct 2007 20:55:24 -0400:

also SQL FTS will throw out the middle character. It knows something is
there, but not what. So it will match on

word!phrase word$phrase and word phrase amoung others.

I think the word|phrase wasn't an explicit string, rather the | represents
an optional value, ie. it would be looking for a word, or a phrase.

--
Dan


.