Hi,

I have some sql

to_char(ASU_total_in_year),999999999.99)

This Displays data in pounds and pence with a decimal point, how can I get
it TO display the amount in just pennies ? i.e.. £10.50 should become 1050
pennies

Any Ideas ?

Cheers

DAN

Oracle LazyDBA home page