>>Is there a SQL-Statement way to change the precision of a field when SELECTING from ond dbf file into another? The source dbf has a numeric field of 20,2 that needs a change to 11,2
>>thanks
>
>Too bad that CAST is not available for you <g>
>
>You may try VAL(PADL(myField,11))

i was really hoping to avoid that.

have a Chag Kosher vSomeach