How about ....
SELECT DUMP(ein) FROM customers WHERE ....
to confirm the ASCII code is what you think it is in the underlying char type
column, then move on from there.
Mike
Sent from my iPhone
On 2 Sep 2016, at 01:40, 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
