Hi,
Let try
Select field1, field2, PADR(ALLTRIM(memo1), 240, " ") from table1
union
Select field1, space(1) as field2, space(240) as memo1 from table2
HTH
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...