In a column I want to replace the second occurance of single char '/' with char(32) I,e. space.
How can I do so?
I am able to locate that value but not able to replace I have a function "count_char" to find the number of rec which has '/' more than once
update #table1 set col1= Replace...
I am able to locate that char by using below string fun