CREATE CURSOR junk ( junk m ) INSERT INTO junk VALUES ( REPLICATE( "X", 5000 ) ) SELECT TRANSFORM( SUBSTR( junk, 1, 250 ) ) AS junk1, ; TRANSFORM( SUBSTR( junk, 251, 250 ) ) AS junk2 ; FROM junk LIST STRUCTUREI get data in both columns with that.
> TRANSFORM(SUBSTR(crsContributions.mNotes,1,250)) AS Description01, ; > TRANSFORM(SUBSTR(crsContributions.mNotes,251,500)) AS Description02, ; >