Hi, I have Number like : 1125.26 Can you help me to syntax return 26 (fractional number).
SQL> select mod(1125.26, 1)*100 fraction from dual; FRACTION --------- 26
Jurij Modic ASCII a stupid question, get a stupid ANSI 24 hours in a day .... 24 beer in a case .... coincidence?
Thanks jmodic, Good Idea.
Forum Rules