SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

remove zeros only to left of number

Joshua_R_WeirFeb 12 2007 — edited Feb 13 2007

Hi,

I want a function that will remove 0 characters only to the left of a number. However the number is in string format.

For example, I want to replace the following string:

'00000010200'

to be

'10200'

I understand that REPLACE('00000010200','0') would remove all 0 characters.

Can anyone provide a solution to this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2007

Added on Feb 12 2007

8 comments

8,740 views