>Hi,
>
>what is the advantage /reason for using a currency data type vs just using a numeric in a table field?
>
>thanks!
Internally, currency data type is integer (8 bytes long, AFAIK), and it gets divided by 10000 for display purposes, and also when multiplying. Therefore, it should be faster for standard financial calculations than the standard numeric type, which is stored as ASCII in tables and as IEEE float in the memory. Currency type doesn't need this sort of conversion, and should perform (basic) calculations faster.