AFAIK, you can't do this using SELECT SQL.

Vlad

>Is there a way in a SELECT SQL, to have 2 memo fields resulted in one memo field?
>
>In my table, I have 2 memo fields. Let say MEMO1 and MEMO2. I would like to do something like this in my SQL:
>
>SELECT MEMO1+MEMO2 FROM mytable...
>
>But, this gives "String is too long to fit". Any workaround for that?