Regular expression help required please

From: Kevin S <searlek_at_googlemail.com>
Date: Tue, 21 Sep 2010 04:31:08 -0700 (PDT)
Message-ID: <d151a343-636a-45c5-9027-762f2e909533_at_c13g2000vbr.googlegroups.com>



Hi All,

From what I understand the sql below should return 'Hello World', however it actually returns 'HelloWorld' i.e. the whitespace is not ignored.

Can anyone tell me what I am doing wrong?

Thanks

SELECT regexp_replace('H\/e l£lo World','[^a-zA-Z0-9]', '') FROM dual; Received on Tue Sep 21 2010 - 06:31:08 CDT

Original text of this message