>Try set exact off and see what happens to your query :-)
>Yau
Most of my tables are joined through integer fields, so SET EXACT is irrelevant in this case.
For character fields, what do you expect to happen with SET EXACT OFF?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)