Hi Moises,

Assuming that the total width of your current field is 26, and you added two field, 1 number 6 characters and the second 20 characters, you could then issue the following statement:

use YourTable
replace all number with left(YourOriginalField,6), name with right(YourOriginalField,20)

in the command window.

HTH

Marc

>The table has only one field with the number and name as the 2 records below
>The number has the same quantity of digits
>
>000060ABDIAS NOBRE
>000523ACACIAS , DAS
>
> How to pass it for 2 fields, the first will contain the
>number and the second will contain the name ?
>
>It's a large table
>
>TIA
>Moises