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

create table test (c1 c(254))
insert into test (c1) values (replicate('X', 254))
create cursor tmp (dummy M)
insert into tmp values("")
select dummy+c1 as memocol from test,tmp