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...
where CountChar(lump,'/')>1
I am able to locate that char by using below string fun
SUBSTRING(col1,charindex('/',col1, CHARINDEX('/',col1,1)+1),1)
-Neil
replace function
Posted - 07/17/2012 : 05:46:36
