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
>>
--sb--