Check the database user's guide. If the basic functions don't do what you want, get the SQL toolkit from your product engineer. It has scores of built-in functions that do everything you need.

Be careful!!!! TRANSLATE is NOT the same as REPLACE (except in a small subset of cases).

There is a true REPLACE function available in the Netezza UDF library I think

D.

As noted by David Birmingham above - there is a true REPLACE function available in the SQL Toolkit.

D.

Talk to your Netezza product engineer and ask for the SQL Toolkit. It has been recently released for TwinFin and has all the stuff you need.  We have recently installed it and you get full access to regular expression operations, including replace, and lots more.