>In my database I have a field, with the following information: Peter Smith Smith; How I can make for it separates the field in three, so that the result is: field 1 Peter, field 2 Smith, field 3 Smith? my database has but of 1000 registers

VFP version ?

infoField="Peter Smith Smith"
#IF VERSION(5)<700
	ALINES(anames,CHRTRAN(infoField,SPACE(1),CHR(13)))
#ELSE
	ALINES(anames,infoField,SPACE(1))
#ENDIF
CREATE CURSOR list (oneName C(50))
dimension anames[alen(anames),1]
append from array anames
BROWSE