Rob,
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.
Regards,
Vijay Sehgal
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 '
(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