Search and Replace comma

Question

Post reply

Search and Replace comma

Terence-701215

Old Hand

Points: 343
More actions
June 3, 2008 at 6:54 am

#186328

Hi All
How do I search for and replace commas?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mark Beringer-730383 SSCommitted Points: 1824 More actions · Answer 1

Check the REPLACE function in BOL:

REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' )

SELECT REPLACE ( 'text1, text2, text3' , ',' , '-' )

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 2

Mark's suggestion is good... if that's what you actually want to do. If not, could you give an example of what you're trying to do? I just wanna make sure that you don't mean that you need a split function...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Terence-701215 Old Hand Points: 343 More actions · Answer 3

Terence-701215

Old Hand

Points: 343

June 4, 2008 at 7:55 am

#824188

Yeah, thanks guys. That works perfectly.