How to replace string on database firebird

How to  replace string on database firebird


select     replace ('Billy Wilder',  'il', 'oog') from  tablemaster_employee where  em_emplcode = 11111