how to remove only comma in the sentence have full of commas

Question

I have Data in my table which comes like this

Attachements,A,B,C,D.

I just want make this

Attachements:A,B,C,D.

I have tried all the Left,right,LTRIM,RTRIM and Replace functions. this not to deal with spaces

Is it always the first one? Is it always after the word Attachements? — Kevin M, Feb 24 '16 at 14:06
Perhaps you could add some more sample data, with variation. — jarlh, Feb 24 '16 at 14:16
Just the same questions with 'Attachments:' prefix was today: http://stackoverflow.com/questions/35594403/appending-messages-in-a-variable-using-coalesce-function/35594483#35594483 You should collaborate in your project team. — Ivan Starostin, Feb 24 '16 at 14:33

score 4 · Accepted Answer · answered Feb 24 '16 at 14:09

4

To replace the first comma you can use:

DECLARE @str VARcHAR(100) = 'Attachements,A,B,C,D'

SELECT STUFF(@str, CHARINDEX(',', @str), 1, ':')

answered Feb 24 '16 at 14:09

Giorgos Betsos

1 Answers1