how to write sql query?

Question

Table : promocode

customerid   promocode
------------------------
1            123a-234b
2            123a
3            123a-234b-345c
4            23s-34f

I want result as

Promocode
--------------
123a,234b
123a
123a,234b,345c
23s,34f

plz help me ........

1) Learn to speak some basic English. 2) Tell us more about your specific problem. What you wrote above does not allow me to help you in any way. — BastiBen
– BastiBen, Commented Nov 13, 2010 at 1:41

OMG Ponies · Accepted Answer · 2010-11-13 01:43:55Z

3

You can use REPLACE to change the hyphen character to a comma:

SELECT REPLACE(t.promocode, '-', ',')
  FROM PROMOCODE t

If you want to write this change to the table:

UPDATE PROMOCODE
   SET promocode = REPLACE(t.promocode, '-', ',')

If there's no hyphen, nothing is updated.

Reference:

REPLACE

answered Nov 13, 2010 at 1:43

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

littlegreen · Accepted Answer · 2010-11-13 01:43:29Z

3

SELECT REPLACE(Promocode, '-', ',') AS Promocode FROM Promocode

answered Nov 13, 2010 at 1:43

littlegreen

7,46010 gold badges48 silver badges52 bronze badges

Comments

Mark Broadbent · Accepted Answer · 2010-11-13 01:50:18Z

2

SELECT REPLACE(promocode, '-', ',') 'promocode' FROM promocode

btw it is not very good practice to be naming your column to be the same name as your table!

answered Nov 13, 2010 at 1:50

Mark Broadbent

4113 silver badges5 bronze badges

Comments

Jesper Fyhr Knudsen · Accepted Answer · 2010-11-13 01:44:51Z

1

Well as far as I can gather from your post, you want to replace "-" with ","

SELECT REPLACE(promocode, '-', ',') AS Promocode
  FROM MyTable

answered Nov 13, 2010 at 1:44

Jesper Fyhr Knudsen

7,9872 gold badges37 silver badges46 bronze badges

Collectives™ on Stack Overflow

how to write sql query?

Table : promocode

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Table : promocode

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related