>>>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
Hag Sameah to you too (haven't gotten this Yiddish accent yet <g>).
If it's not broken, fix it until it is.
My Blog