I just KNEW you guys would have it!!! Thanks a billion!!!!!
And I forgot about the union all... thanks for reminding me.
>The usual trick is following:
>CREATE CURSOR tmp1 (dummy M)
>Insert Into tmp1 Values('')
>Select *,tmp1.dummy as Mymemo From Mytable,tmp1
>
>You may use the last line as part of UNION. Also, I think you may better use UNION ALL working with memos.
~~~~~~~~~~
Denise
~~~~~~~~~~