sai reddy

sai reddy

  • NA
  • 18
  • 6.8k

Replace a special charcter in a column at the end

Aug 31 2017 8:56 PM
My column values are
 
ID
1
3
5
6
7
....
 Here len(id)=2
  Where beside the values i found the special character that is ASCII(RIGHT(ID,1)) =13
 
My question is, how to replace that special character with 'a' ?

Answers (2)