title: Sybase replace function
body: <p>I am unable to use sybase <code>replace</code> function to replace data.
  Basically what i need is to update all the occurrences of <code>'abc'</code> and change with <code>'zzz'</code>.]
  <code>table_clmn</code>  is data type text
  I am using the following sql --</p>
  
  <pre><code>update  table
  set table_clmn = replace(table_clmn , 'abc', 'zzz') WHere id in (1, 2)
  </code></pre>
  
  <p>I get the following error </p>
  
  <blockquote>
    <p>Incorrect syntax near the keyword 'replace'. </p>
  </blockquote>