How to replace in sql

[visweswaran2830]

let output string will be,

str="01/Mar/2010,02/Mar/2010,03/Mar/2010,04/Mar/2010,05/Mar/2010"

Some manipulation, *******

Resultant string should be,

"01/Mar/2010,02/Mar/2010<br/>03/Mar/2010,04/Mar/2010<br/>05/Mar/2010"

Here I want to replace Comma (,) by <br/>

Note:

I want to replace even commas only. (before 03/mar/2010 & 05/Mar/2010..like)

[ThatThatGuy]

This will work

SELECT REPLACE(yourstring_column,',','<br/>') from Sometable

[visweswaran2830]

I dont want to replace all of my commas, I just want to replace alternate commas only.How can I acheive

[ThatThatGuy]

I dont want to replace all of my commas, I just want to replace alternate commas only.How can I acheive

Then you might need to use a different separator other than comma(,)... probably a hyphen(-)