Hi Kirk,

Don't use ALLTRIM() because VFP doesn't have variable lenght character fields. You can get result you want in two steps.

SELECT uestdesc, IIF(isRequired,"1","0"), STR(recordid) ;
  FROM curquest 
  INTO ARRAY latemp1
FOR i=1 TO ALEN(latemp1,1)
  latemp1[i,1] = ALLTRIM(latemp1[i,1]
  latemp1[i,3] = ALLTRIM(latemp1[i,3]
ENDFOR

>Are there known limitations of using a sql select into an arry where one of the select fields is a memo? I didn't have any problems with this code until I entered a long string that has CRLF in it. Now I get a String to Long To Fit message:
>
>

>SELECT ALLTRIM(questdesc),IIF(isRequired,"1","0"),ALLTRIM(STR(recordid)) ;
>	FROM curquest INTO ARRAY latemp1
>

>
>where questdesc is a memo field.
>
>Kirk