Try

? LEN(TRANSFORM(a))

>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