Replace two values

• jondy87

  SSC-Addicted

  Points: 426

  More actions

  November 21, 2010 at 9:50 pm

  #142639

  Hi

  I want to remove multiple characters (that are not necessary sequential) in a string.

  To remove the character 'a' from a string I use the following:

  REPLACE(mystring, 'a', '')

  But if I want to remove all 'a's 'b's and 'c's how do I do it?

  The following does not work but displays the logic I need:

  REPLACE(mystring, 'a' | 'b' | 'c', '')

  any ideas

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  November 21, 2010 at 11:40 pm

  #1253586

  You will have to use a nested REPLACE for this like the below example

  DECLARE@strVariable VARCHAR(100)

  SET@strVariable = 'a1b2c3'

  SELECTREPLACE( REPLACE( REPLACE( @strVariable, 'a', '' ), 'b', '' ), 'c', '' )

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/