thnx nice one 🙂

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

as suggested by you... even this returns the same output