>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?
You can try trimming the contents of the memo field to shorten the overall return field's space. Something like:
SELECT ALLTRIM(memo1)+ALLTRIM(memo2) FROM mytable...
else, you might have to select both fields in your SELECT and combine the info into one variable by code.
John
It's "my" world. You're just living in it.