>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))
If it's not broken, fix it until it is.
My Blog 
