Hi,

I am experiencing a strange behavior in a full text search using the
CONTAINS predicate.

SELECT SomeField
FROM SomeTable
WHERE  CONTAINS(SomeField, 'D-2001-286')

The result is
SomeField
----------------
D-2001-286
D-2002-286

The only explanation that could make some sense regarding the second
line in the result is the precense of the dash (-) caracter.  I did not
found any information regarding this caracter in a CONTAINS expression.

By trial an error, I found that the following query returns a list of
values that does not correspond to the value sought.

SELECT SomeField
FROM SomeTable
WHERE  CONTAINS(SomeField, '"D*"')

The result is
SomeField
----------------
02-00005-8601
134500-04-0003
88-03-27

and so on.

Any ideas why this is appening ?

Thanks in advance

Pierre Boucher