Regex

Hi All,

Is there a way to execute a regex, inside a SELECT
statement, to substitute things?

For example:

SELECT name FROM mytable;
name
---------
john
michael
robert
richard
chandler

I want to substitute all "r" to "-"

SELECT myfunction(name) FROM mytable;
name
---------
john
michael
-obert
-icha-d
chandle-

Any idea??

Thanks in advance,
Regards,

Marcelo P.
Brazil

_______________________________________________________
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora!
http://br.acesso.yahoo.com