If there're more or less then 3 words they could end up in the wrong fields or be lost after split.

>Hi,
>
>Why *exactly* three ?
>
>>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
>>