update customers set ein = replace(ein,'''');
Worked for me, but if you want to continue and work on this later you can use
substr in update for now.
On Sep 1, 2016, at 8:40 PM, Rob Lockard <rob@xxxxxxxxxxxxxxxx> wrote:--
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 '
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" -Douglas
Robert P. Lockard, Oracle ACE