Replace a special charcter in a column at the end

Question

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(ID1)) =13 My question is how to replace that special character with 'a' ?

Rajkiran Swain · Answer

https://dba.stackexchange.com/questions/126127/replace-special-characters-in-a-column-with-space

Ramesh Palanivel · Answer

Hi Sai reddy Please refer this link to replace the character in string. Please Note : the column value should be varchar or nvarchar https://docs.microsoft.com/en-us/sql/t-sql/functions/replace-transact-sql