Your second column would end up being 500 characters in length, which I believe would force it to a memo. From your earlier description, don't you want something more like this?

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 STRUCTURE

I get data in both columns with that.

>Sounded like a great idea, but only the first one (Description01) contains any values after the SQL runs. Any reason why the 2nd and subsequent ones would be empty?
>
>
>

>	TRANSFORM(SUBSTR(crsContributions.mNotes,1,250)) AS Description01, ;
>	TRANSFORM(SUBSTR(crsContributions.mNotes,251,500)) AS Description02, ;
>