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
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.