----------------------------------------------------------------------------------------------------------------------------------------------------------------------

You can check my BLOG here

SELECT REPLACE('Hello world',NULL, 'zzz' );

I learnt new thing today. Thanks Ronmoses.