2
Reply

Replace a special charcter in a column at the end

sai reddy

sai reddy

Aug 31 2017 8:56 PM
188
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)