>>>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.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up