That character is the EN Dash. Are you by chance copying and pasting
from MS Word or some other program that does smart replace while you
type? I don't see this character in your select. Is there something
else that is running that may be causing this problem?
-Aaron
On 6/14/06, Sergey Levche
am 08.09.2005, um 23:25:05 +0200 mailte "Michael Höller" folgendes:
> Hello,
>
> I initially thought this is simple.. I want to relpace a character to
> nothing. Eg. relace "B" to "" -> ABCD to ACD.
In the new version 8.1 there are a regex_replace() - function. A other
solution: write your own
Michael,
You practically solved it yourself in the subject of the email ;)
select replace('abcd','b','') from your_table;
Hope that helps,
Anthony
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Michael Höller"
Sent: Thursday, September 08, 2005 5:
Michael Höller wrote:
> Hello,
>
> I initially thought this is simple.. I want to relpace a character to
> nothing. Eg. relace "B" to "" -> ABCD to ACD.
>
> All me approches vaild but I am sure that I have seen it already and
> think it was not tricky..
>
> Can someone please help me ?
From t
