>UNION in VFP8 has been enchanced so it can imlicitly convert field types to make SELECT's UNION-compatible. This works in VFP8.

Create Table c:\temp\table_memo ( mField m )
>Create Table c:\temp\table_char ( cField c(50) )
>Select mField As cResult ;
>	From Table_Memo ;
>Union ALL ;
>Select cField ;
>	From Table_Char
>

Well, that is great. Thanks