This code exemplifies what I want to do:

create table test (c1 c(254))
insert into test (c1) values (replicate('X', 254))

select (testa.c1 + testb.c1) as MemoCol from test testa, test testb

How can I make the column named MemoCol a memo field?