Contains ..

hi,
what is the diff. between contains(myfield, ' "the app" ') and
contains(myfield, ' "the app*" ')?
i still dunno what is the diff.
Thanks
Q wrote on Fri, 13 May 2005 17:04:43 +0800:

> hi,
> what is the diff. between contains(myfield, ' "the app" ') and
> contains(myfield, ' "the app*" ')?
> i still dunno what is the diff.
The * is treated as a wildcard when used inside the quotation marks. For
example, the 2nd version will find
the apple
as a phrase in the fts index, but the first version won't as app is treated
as a whole word.
Dan
|||Just to piggy back on Dan's remarks. The wildcard applies to each token in
the search phrase, so not only would it find "the apple", but it would also
find "theta apple" - assuming the is not in your noise word list.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Daniel Crichton" <msnews@.worldofspack.co.uk> wrote in message
news:%23$C5rT7VFHA.3084@.TK2MSFTNGP10.phx.gbl...
> Q wrote on Fri, 13 May 2005 17:04:43 +0800:
>
> The * is treated as a wildcard when used inside the quotation marks. For
> example, the 2nd version will find
> the apple
> as a phrase in the fts index, but the first version won't as app is
treated
> as a whole word.
> Dan
>
|||Hilary wrote on Fri, 13 May 2005 09:58:49 -0400:

> Just to piggy back on Dan's remarks. The wildcard applies to each token in
> the search phrase, so not only would it find "the apple", but it would
> also find "theta apple" - assuming the is not in your noise word list.
I missed that bit, thanks Hilary. Something for me to consider in my next
look at optimising my search code ...
Dan
|||ok, thanks!
"Daniel Crichton" <msnews@.worldofspack.co.uk> glsD:eP%23J%23c8VFHA.3424@.TK2MSFTNGP09.p hx.gbl...
> Hilary wrote on Fri, 13 May 2005 09:58:49 -0400:
>
> I missed that bit, thanks Hilary. Something for me to consider in my next
> look at optimising my search code ...
> Dan
>