I have data values that resemble the below format.
R0102447 / R0102448
I want to replace the " / " with a ",". I tried with the below code but it does not work.
UPDATE DSCNSkpiUpdate2 SET DSCNSkpiUpdate2.Rank = Replace(Rank," / ",",");
Any ideas how to fix this?