Thunderstone Support Forums

Why would a column full of numbers return hits for matches of parts of the numbers?

TSQL > select groups from article2 where groups like '(50)' ;

groups
------------+
50164 7651
10329 61350 61560 45980 90344
...etc.

The index was created without any addexp's in effect.

Was the Metamorph index created on just the groups field? Is it up to date?

Yes the index was just on the groups field, no it wasn't up to date. The problem went away when I brought the index up to date. What's up with that, do you know?