Strip Character in Middle of String

[Anon]

I have an Oracle DB table called ORDER with data in a column called AMOUNT. The values in AMOUNT have a decimal point -- I want to eliminate the decimal point.

For example, I have 2 rows where ORDER.AMOUNT = 23.33 and ORDER.AMOUNT = 1.00

I want to get rid of the decimal point so that the rows would be ORDER.AMOUNT = 2333 and ORDER.AMOUNT = 100

I've tried using an update with TRIM, LTRIM and RTRIM but can't get it to work.

Any suggestions?

THanks

[Anon]

update order
set amount = replace(amount,'.')

[Anon]

Thanks Lars. This worked like a charm!