title: Problem with Replace Function
body: <p>In one of my resultsets i have column with char - data. I want to create another column, which carries altered data from the first column. There i want to exchange all 'ö' with oe. </p>
  
  <p>I tried it like this:</p>
  
  <pre><code>Select NAME1,
      case when POSSTR(NAME1, 'ö') is not null then REPLACE(NAME1, 'ö', 'oe')
      end As __NAME1
  from xyz;
  </code></pre>
  
  <p>and it failed. I don't get an error, but the ö is not replaced. </p>
  
  <p>Am i making a mistake or is it simply not possible to perform this operation?</p>
  
  <p>Thanks!
  Patrick</p>