Hi Borislav, thanks for your reply,

Yes that would be ok .. do you know if it will have an
impact on speed and size ?
Regards,

Gerard


>>Hi.
>>I have a Data Warehouse type application which uses very large files with lots of fields (Typically 130 fields in each table)
>>
>>These have always been set up as N(13,2), and they take up a lot of space
>>(If I zip them I can get 90 % reduction)
>>
>>I;m wondering if I use some of the other data types will they:
>>1. Increase Processing speed
>> (These are updated regulalrly)
>>2. Reduce the size of the tables
>>
>>Regards,
>>
>>Gerard
>
>What about to change the type from Numeric to Currency? Currency type uses 8 bytes and in it can be stored values from -$922337203685477.5807 to $922337203685477.5807.