Hi David.

Is INT as the name suggests, an integer without decimals.
If this is the case, it would not suit as fields have to accomodate
9999,999,999.99 minimum

Regards,

Gerard

>Gerard,
>
>The int is probably the fastest calculationally because there is no conversion to/from ASCII, provided your data fits in it. Int takes 4 bytes.
>
>If you need to use N fields make sure they are appropriately sized, using n(13,2) for everything is probably a non-optimal solution.
>
>>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