another option for memo is to include memo in both select statements (worked for me because the table containing memo wasn't one of the critical ones)

>for datetime you can use CTOT() etc.
>but for memo I think to only option may be to create a cursor manually and
>add it into the SQL
>
>Arnon
>> what are the placeholders for memo fields and datetime fields in select
>> union statements? character and date don't seem to work...
>>