>I tried that, it only seems to work with expressions of 2 terms. The following does not work:
>
>
>create table test1 (c1 c(254))
>create table test2 (c1 c(254))
>insert into test1 (c1) values (replicate('X', 254))
>insert into test2 (c1) values (replicate('X', 254))
>create cursor tmp (dummy M)
>insert into tmp values("")
>select dummy+test1.c1+test1.c1 as memocol from test1,test2,tmp
>
Would
select dummy+test1.c1+test2.c1 as memocol from test1,test2,tmp
matter? You've used test1 twice in your last line.
Nope, it doesn't work even that way. I've tested a dozen variants, and they all give "String too long to fit".