Thanks sergy for the reply

do you know how to display length of a numeric number.

a=10000
?LEN(str(VAL(str(a)))) return 10 ???

txs

>You can run select into cursor and than add records to a table. In VFP8 you'll be able to do that in one command INSERT INTO SELECT FROM.

>select * from temp into CURSOR crsCatalog
>SELECT catalog
>APPEND FROM ( DBF("crsCatalog"))
>* or if you want to add all records from 'temp'
>APPEND FROM ( DBF("temp"))
>

>
>>hello all
>>
>>how to add the result of a query into a database where in the table already exist in the database.
>>
>>eg select * from temp into table catalog database mydbc gives a error message
>>
>>catalog.dbf already exists as part of a database.
>>
>>txs