>>>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.
>
You can use Alter Table command to change field size. Make sure that data really fits to new size.
Edward Pikman
Independent Consultant