> 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? Couple of, but you won't like it :) #1: Select them both, then reopen the cursor (classical Use (dbf()) again alias newcurs), and Replace All memo1 with memo1+memo2 #2: Select none, but add record number: select this, that, recno() as rcn from ... set order to 0 in source_table set rela to rcn into source_table_alias This is somewhat quicker, since you don't really Select the memos, and you probably don't need all of the memos all of the time. If that is the case, you can always do something like dummy_memo=original.memo1+original.memo2 while processing a single record. If you really need all of them at once, this may not be the best.