>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

If there're exactly 3 words in the field than

SELECT mytable
SCAN
  REPLACE ;
    field1 WITH GETWORDNUM(field123, 1), ;
    field2 WITH GETWORDNUM(field123, 2), ;
    field3 WITH GETWORDNUM(field123, 3), ;
ENDSCAN