>It has nothing to do with CAST(). The UNION does implicit DISTINCT on the result set and such operation is not supported for Blob, General, Memo, etc. You should use UNION ALL to avoid it.
Sergey, thanks once again for the fix. (You too Naomi.)
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn