Grasping at straws, but if your update says it updates but data hasn't
changed, I'd ask if you are sure that it is actually a normal single quote
in your data? Could it be a "smart quote" for example originating from a
Windows Office auto-replace rule? You could test it with:
select ascii(substr(ein,1,1)) from customers;
Then see if it is actually 39?
(Or it could be maybe a UTF multibyte character?)
Just a wild guess...
Kim Berg Hansen
On Fri, Sep 2, 2016 at 2:40 AM, Rob Lockard <rob@xxxxxxxxxxxxxxxx> wrote:
This should be easy, maybe i've been working it for too long, or don't
Anyway, I have a column that wound up getting populated with a leading '
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
"Rules are for the obedience of fools and the guidance of wise men"
Robert P. Lockard, Oracle ACE