SELECT LEFT(myfield,6) AS ID, SUBSTR(myfield,7) AS Name ;
FROM mytable ;
INTO CURSOR crsTwoFields
>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
--sb--