Tom,

See my reply where I discussed SET EXACT, the same is true for SET ANSI ON it is not the same as ==

>If SET ANSI is set to OFF then the result will be as you have indicated as GAMMA is contained within GAMMARES.
>
>You can also use == to indicate "exactly equal to".
>
>Tom