469,289 Members | 2,273 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,289 developers. It's quick & easy.

How to replace in sql

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)
Jun 10 '10 #1
3 1292
ThatThatGuy
449 Expert 256MB
This will work


Expand|Select|Wrap|Line Numbers
  1. SELECT REPLACE(yourstring_column,',','<br/>') from Sometable
Jun 11 '10 #2
I dont want to replace all of my commas, I just want to replace alternate commas only.How can I acheive
Jun 14 '10 #3
ThatThatGuy
449 Expert 256MB
@visweswaran2830
Then you might need to use a different separator other than comma(,)... probably a hyphen(-)
Jun 14 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Craig Keightley | last post: by
6 posts views Thread by JackpipE | last post: by
15 posts views Thread by =?Utf-8?B?TWlrZSAiWU9fQkVFIiBC?= | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.