Actually, Dan, I think you get .1521 rather than 15.0021. Currency has always worked this way (2.11 is the earliest I have worked with).
However, a brief script can be used to fix it, if you walk a cursor down all the Currency columns in SYS_COLUMNS to do the 100x update. --- Dan Goldberg <[EMAIL PROTECTED]> wrote: > I am getting ready to change from 2 currency digits to 4 digits. Instead of > adding two zeros to the end it moves the decimal over two places and appends > two zeros. > > Old > > $15.21 > > New > > $15.0021 > > Does anybody have a trick to do this change without going into every table > and multiplying all the currency columns by 100?? > > Dan Goldberg > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
