Hello,

We recently migrated to the Windows 2003 and SQL2005. Besides many
things we have not pretty much tackled, there is one issue remaining
that I don't understand: Consider this query:-

SELECT TOP 250 *
FROM [news]         [news] INNER JOIN
     CONTAINSTABLE([news_recent], [content],
                   '("J* K*")'
                   ) AS con ON [news].[id] = con.[key]

Language setting is Neutral, both "J" and "K" are in the noise word
list.

The result of this query is that it treats this as an OR query, i.e.
every record that contains a word beginning with a J, or a word
containing with a K. And that is quite a few hits indeed..

Why is the space interpreted as an OR, more importanly, what do I need
to do to get rid of it? In the previous version it was sufficient to
put something like this between quotes. I've tried many variations of
adding quotes, none have given me the expected result.

Cheers,

René de Vries

P.S. version info:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005
00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Standard
Edition on Windows NT 5.2 (Build 3790: Service Pack 1)