Find and replace ASCII Character

• yogi123

  SSCrazy

  Points: 2932

  More actions

  November 6, 2017 at 10:56 am

  #341197

  Hello,

  I have to build something that will find ASCII character and replace them with blank values,

  example, Koç to Ko.

  Can anyone please help me to do this?

  Thanks

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  November 6, 2017 at 11:35 am

  #1966857

  yogi123 - Monday, November 6, 2017 10:56 AM

  Hello,

  I have to build something that will find ASCII character and replace them with blank values,

  example, Koç to Ko.

  Can anyone please help me to do this?

  Thanks

  SELECT REPLACE( Somecolumn, CHAR(231), '')
  FROM SomeTable

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2