>>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.

This can only be done the long way:

Select MemoField ;
	From Table_Memo ;
	Into Cursor curTest ;
	ReadWrite

Select CharField As MemoFieldName ;
	From Table_Char ;
	Into Table c:\Temp\NewTable

Select curTest
Append From c:\Temp\NewTable
Use In NewTable
etc.

The As MemoFieldName is required, so that the Field Names match during the APPEND.