Re: Regular expression help required please

From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Tue, 21 Sep 2010 05:55:07 -0700 (PDT)
Message-ID: <208556d4-0481-4958-a99c-71051fcaa881_at_k30g2000vbn.googlegroups.com>

Hi,
a simple solution is this
SELECT regexp_replace('H\/e l£lo World','[^ a-zA-Z0-9]', '') FROM dual;

but it produces this "He llo World"

The questions is what is the different between the space in "/e l" and the other space in "o W" ?

If you have an answer there might be a rule to discribe it.

regards
Kay Received on Tue Sep 21 2010 - 07:55:07 CDT