Hi Igor,

Your code runs w/o problem in VFP6SP5 but generates an error in VFP7/8. Looks like this bug was introduced in VFP7 and carried into VFP8.

>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.