>>>Thank you so much! I tried it and it bombed big time. :-)
>>>
>>>No fault of yours of course. The code does not account for NULL values. I went in the table that had the null fields and took them out. It all worked fine then.
>>>
>>>How would I account for NULL values in this code?

>>SELECT ;
>>  IIF(ISNULL(A.NullFld), "", A.NullFld) AS NoNulls, ;
>>  ...

>
>Actually, it'd probably be better to use NVL(), as inL
>
>SELECT NVL(a.nullfield,''), ;

Thanks for the heads up. That's a function I've never used, and it's perfect for this job.