I think I ran into a bug in VFP, as decribed below. I wonder whether anybody knows a workaround.

The problem is that SQL SELECT .... INTO CURSOR generates an error (String is too long) if memo field used to create new column in destination cursor is a part of expression (ALLTRIM, TRANSFORM, etc.).

Steps to reproduce:

CREATE CURSOR a1 (bb M)
APPEND BLANK IN a1
REPLACE bb WITH REPLICATE('a', 2000) IN a1

Now, the following works:

SELECT a1.bb as dd from a1 INTO CURSOR c1

While, the following generates an error:

SELECT TRANSFORM(a1.bb) as dd from a1 INTO CURSOR c1

This error exists if any function used against the originam memo column: TRANSFORM, ALLTRIL, RTRIM, etc.

Thank you,
Igor.