This project has moved. For the latest updates, please go here.

How to replace in sql

Jun 10, 2010 at 5:48 AM

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)

Coordinator
Jun 10, 2010 at 9:12 AM

I do not understand what you want...

If you want a break, then put a break in it...

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

=>

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