PMFJI
Transform() or substr(string,N,M)+'' might cause to lose data.
Use something else as Hilmar and Fabio said (Left() or Padr()). ie:

LOCAL lnPieces,lnLen,ix
lnPieces = 10
lnLen = 250
Set Textmerge To Memvar m.lcScript Noshow
Set Textmerge On
\\select
For ix=1 To 10
\\ LEFT(SUBSTR(notes,<<(m.ix-1)*m.lnLen+1>>,<<m.lnLen>>),<<m.lnLen>>) as Piece<<PADL(m.ix,2,'0')>>
  If m.ix<m.lnPieces
\\,
  Endif
ENDFOR
\\ from Employee into cursor crsSliced
Set Textmerge To
Set Textmerge Off
EXECSCRIPT(m.lcScript)
BROWSE WIDTH 20

Cetin



>Doh! I was thinking that the 2nd number was the ending position, not the length. Thanks!
>
>>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, ;
>>>