SQL query question about removing characters?

[jeena1]

Hello,

is there a way to write a sql query that will extract "-" dashes from a field? for instance the field contains 111-111-111, i want to get 111111111 as the result of my select statement, THanks.


___________________

edit: no commercial links permitted on the forum

[gandolf989]

That isn't so hard.

SQL> select replace('999-99-9999', '-', '') from dual;

REPLACE('
---------
999999999