I'm stuck replace(column, '''') and replace(column,chr(39)) not working

From: Rob Lockard <rob@xxxxxxxxxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 1 Sep 2016 20:40:21 -0400

This should be easy, maybe i've been working it for too long, or don't know.

Anyway, I have a column that wound up getting populated with a leading ' (single quote)

update customers set ein = replace(ein,''''); and update customers set ein = replace(ein,chr(39)); does not work. Well, the message says updated but when I query the table, it's still there. There is something simple that I'm missing and for the life of me, I can't figure it out.

The definition of insanity is doing the same thing over and over expecting different results. By that definition; I've been insane for the past two hours.
-Rob

--
================================
"Rules are for the obedience of fools and the guidance of wise men" -Douglas
Bader
Robert P. Lockard, Oracle ACE
www.oraclewizard.com
(c) 571.276.4790
Twitter: @YourNavionPilot

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: I'm stuck replace(column, '''') and replace(column,chr(39)) not working
  - From: Jack van Zanen
- Re: I'm stuck replace(column, '''') and replace(column,chr(39)) not working
  - From: Hans Forbrich
- Re: I'm stuck replace(column, '''') and replace(column,chr(39)) not working
  - From: Vijay Sehgal
- Re: I'm stuck replace(column, '''') and replace(column,chr(39)) not working
  - From: Kim Berg Hansen
- Re: I'm stuck replace(column, '''') and replace(column,chr(39)) not working
  - From: Michael D O'Shea/Woodward Informatics Ltd
- Re: I'm stuck replace(column, '''') and replace(column,chr(39)) not working
  - From: Michael Cunningham

I'm stuck replace(column, '''') and replace(column,chr(39)) not working

Other related posts: