add charcter end of the string
i have table like below
sno name code id
1 asvr 123 3
2 ramu 789 7
3 raju 456 3
4 praveen 876 3
i want o/p like when id=3 add character "r" to end of code ..like below ...
sno name code id
1 asvr 123r 3
2 ramu 789 7
3 raju 456r 3
4 praveen 876r 3