Jose,
You will need to change the SqlPrep command to

sqlprep(1,"select * from tablex where cod='01' and number>='000' and number <=99'","tabley")

so it will include '000' and '999' in your end result.

Could you explain more about how records are changed? Are you getting duplicate "number" values?

Barbara

>I am using:
>
> sqlprep(1,"select * from tablex where cod='01' and number>'000' and number <'999'","tabley")
>
>sqlexec(1)
>
>The results in the cursor "tabley" apparently they are ok but, some records are changed, not always the same.
>For example the remote table have 1000 records with a field 'number' with the value 000 to 999, there is not duplicate records.
>When run the query i have the 1000 records, the value of field number in one o more records is changed for any value.
>Any idea please.
>Thank you, excuse my english