>You need to make the fields UNION compatible using the following:

Create Table c:\temp\table_memo ( mField m )
>
>Create Table c:\temp\table_char ( cField c(50) )
>
>Select Padr( mField, 100 ) As cResult ;
>	From Table_Memo ;
>	Into Cursor curTest ;
>Union ;
>Select Padr( cField, 100 ) ;
>	From Table_Char

Yes, this is exactly how I saw it at first. But, if I have a memo, that's because I have some values over 250 characters. I thought I would run into problems at one time or another because of the restriction of the character field versus the memo field. IAC, for now, I found that I no longer need the second part of the SQL. But, it is an interesting issue to deal with.