At 07:51 PM 1/17/2004, Bob Murdoch wrote:

>So the question is, given an application using US dollars, is there any
>value to using numeric(9,2) instead of numeric(18,2)?

I don't think so. Most business's hope to exceed $1M eventually.

>And is numeric(x,2) correct for dollars?

Fine.

>Oh, and one last question - if there is no value to (9,2), is there any
>harm in changing that to (18,2) in existing applications?

No, it will use somewhat more storage, but you'll avoid the
embarrassment of discovering that your business just went from
doing $9,999,999.99 worth of business to -$0.01.

Regards,


Ann