Re: Getting the 2 first numbers ???

From: Frank <franjoe_at_frisurf.no>
Date: Wed, 28 Mar 2001 22:44:25 +0200
Message-ID: <M2sw6.659$R6.16908@news1.oke.nextra.no>

Hi!

SELECT LPAD(

                            TRUNC(
                                    (12978892/97  - TRUNC(12978892/97)
                                    )* 100
                            )
                    ,2,0)

FROM dual;

You will probably get in trouble with the rounding :-)

Frank Received on Wed Mar 28 2001 - 14:44:25 CST