>>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.
I tried the ALLTRIM this morning and it is not working.
The reason I want to have all in one field is to avoid changing one of my main functions.
Thanks.