title: How to replace full substring in Netezza
body: <p>Netezza sql manual say there is translate(s, from, t) function while this function will replace each character in 'from' to corresponding character in 't', for example: translate(‘
  12345’,’14’,’ax’) returns ‘a23x5’.</p>
  
  <p>but if I want to replace 'full' string, for example: translate('123135', '12', 'ab') returns 'ab3135'. how to make it?</p>