title: Remove special character chr(191) and others SQL
body: <p>Bit novice to the unix scripting and Oracle commands so be easy...</p>
  
  <p>I have a field which gets populated with incorrect characters and specially the chr(191) ' inverted ? sign'.. </p>
  
  <p>I had this sample code </p>
  
  <pre><code>UPDATE rc.rc_descripton
  SET desc_description = 
                          (
                           CASE 
                              WHEN desc_description LIKE '%[^a-zA-Z0-9]%' 
                                    THEN Replace(REPLACE( desc_description, SUBSTRING( desc_description, PATINDEX('%[~,@,#,$,%,&amp;,*,^,&amp;,%,*,(,)]%', desc_description), 1 ),''),'-',' ')
                              ELSE desc_description
                            END
                           )
  </code></pre>
  
  <p>Though my original UPDATE command was :-</p>
  
  <pre><code>UPDATE rc.rc_description
  SET    desc_description  = REPLACE(desc_description, CHR(191), ' ')
  WHERE  desc_description LIKE '%' || CHR(191) || '%'
  </code></pre>
  
  <p>I want to incorporate the above code to the main sample code i have posted above.</p>
  
  <p>I did found an unix script that was being used earlier :</p>
  
  <pre><code># Replace offending characters with the intending/valid characters 
  
  sed s/–/-/g $1 | sed s/’/\'/g | sed s/‘/\'/g | sed s//\'/g | sed s//\'/g | sed s//\"/g | sed s//\"/g | sed s/“/\"/g | sed s/”/\"/g | sed s/—/-/g | sed s//-/g | sed s/…/.../g | sed s/‑/-/g | sed 's/½/1\/2/g' | sed 's/¼/1\/4/g' | sed 's/¾/3\/4/g' | sed 's/· //g' | sed s/°/./g | sed s/•/*/g | sed s/ //g &gt; $1.out
  </code></pre>
  
  <p>But I cant translate the unix code to the Oracle update command..</p>
  
  <p>please advise of the correct UPDATE command to cater to all set of special characters as above and to take into consideration the CHR(191) too...</p>
  
  <p>sincerely,
  A.B.</p>