Replace Function

[shivampurwar]

Hi,

I have query like that
select REPLACE('ab cd.-', ' -.' ,'_');

I want o/p:--ab_cd

How can i achieve it in single replace function