Sergey,
You're the greatest!!!
Thank you for saving my sanity!
I'll go check this now.

...I just checked it and yes ansi is off!
You're the man!!!

Thank you!
Rick

---------------------------------
>Rick,
>
>MS KB article Q142887 states that "Using an ALLTRIM() function with an SELECT-SQL statement when SET ANSI OFF may result in the return of an incorrect subset of records."
>
>
>