CLEAR

CREATE CURSOR junk ( junk m )
INSERT INTO junk VALUES ( REPLICATE( "X", 5000 ) )

* This way gets a memo column
SELECT SUBSTR( junk, 1, 250 ) AS junk FROM junk
LIST STRUCTURE 

* This way gets a character column
SELECT TRANSFORM( SUBSTR( junk, 1, 250 ) ) AS junk FROM junk
LIST STRUCTURE