Re: I'm stuck replace(column, '''') and replace(column,chr(39)) not working

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_at_oraclewizard.com> 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: _at_YourNavionPilot
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l