Re: Help with trimming value in PL/SQL

abs(trunc(mod(your_number, 1), 2))

If You have only positive numbers, abs is redundant.

--
 Alexander I.Doroshko, aid_at_grant.kharkov.ua

• Bank "Grant", Kharkov, Ukraine

Brian Howard <bkhoward_at_flash.net> wrote in article <WBKT3.1978$w9.224641_at_news.flash.net>...
: I have a column with numbers such as
:
: 1043.99
: 434345353.9943242
: 564.99245453
:
: How do I trim the column in order to get just the 99(hypothetically)
which
: always falls as the first two digits after the decimal. In other
words I
: want it to return the first two digits after the decimal point
(without
: rounding first). Suggestions?
Received on Wed Nov 03 1999 - 03:30:10 CST