Re: CONTAINSTABLE - weird results - using "and not"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I did a little more research...and I am thinking that because I use a
wildcard "*" to indicate the column, if say I used

CONTAINSTABLE(ICDB.dbo.SearchT­able, *, '(( "rte*" ) AND ( "billing*"
) AND ( "opt*" ) AND ( "editor*" )) and NOT ( "integer*" )')

Both rte, billing, opt, and editor would need to be in the same column
that integer is not in. So if rte, billing, opt, and editor were in
say the title column, and integer was in the description column...it
would not correctly filter out those records with integer in the
description.

Does this make sense? Any ideas?

.