Hi, Rob
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...
Regards
Kim Berg Hansen
http://www.kibeha.dk
kibeha@xxxxxxxxx
@kibeha <http://twitter.com/kibeha>
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
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