At 08:22 PM 1/04/2006, you wrote:

> > >yes, the currency field may have very high number (billion, FYI my
> > >currency is Indonesian Rupiah) for single record entry and could be
> > >more than billion for Total field. I just need 2 digit after decimal
> > >and it will highly used. What is proper data type for handling my
> > >currency?
> > >
>
>mmm... what about above question, any suggestion? will NUMERIC(18,2)
>be sufficient enough?

Others will no doubt weigh in here (one hopes! though you might have
to wait until after the weekend...)

The largest 2-decimal exact numeric available to you is
92,233,720,368,547,758.07. Only you can work out whether it is
enough and how you will handle calculations involving numbers that
might overflow this maximum. Some who have to work with enormous
numbers solve the problem by working some calculations in doubles
and/or with exponential numbers. The accountant's rules will usually
dictate what your strategy has to be. This is something that must be
established before you start creating tables.

Geoff Worboys wrote an interesting paper a few years ago that might
help. You can download it here:
http://www.ibobjects.com/TechInfo.html#ti_Numerics

./heLen