>Dear Experts
>
>nval1=342.36548
>
>I want to divide it into two parts as
>Int part will be first part
>Two digists after decimal will be the second part
>
>For example
>nval2=342
>nval3=36
>
>Please help
nval1=342.36548
nval2=INT(342)
nval3=INT((nval1-nval2)*100)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.