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!

Trim non-breaking space

671659Jun 18 2009 — edited Jun 18 2009

I have got some columns imported with leading non-breaking space (chr(160)) when I imported them from excel. I need to clean it up. How do I trim the non-breaking space out of the column.

I tried replace(column, chr(160), '') but that did not work. Can anyone help me with this? Any help is greatly appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2009

Added on Jun 18 2009

5 comments

7,122 views