>Hilmar,
>I tested the set exact status using a single table query.
>For character field joins, off course you need to have exact on.
>But what I've discovered is that with set exact off, a query runs faster and nothing more.
>Yau

I haven't tested recently, but long ago, it used to be that you wanted SET EXACT and SET ANSI to be set the same way. Be aware that SET EXACT doesn't have any effect in queries.

Tamar