Replacing Specific Characters in a Text String

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  October 21, 2003 at 1:05 pm

  #176806

  Hello,

  I have a situation in which I need to replace apostrophe characters with a space, within a text string. I need to do this edit in a nvarchar 20 field that contains last names.

  For example, if I have a lastname of O'Neil, that name needs to be edited to become O Neil.

  I am working with some String Functions now, but I wanted to check to see how others might handle this.

  Thanks

  CSDunn

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  October 21, 2003 at 1:18 pm

  #478995

  Why not just use REPLACE()?

  
  
  UPDATE People
  
  SET LastName = REPLACE(LastName,'''',' ')
  
  WHERE LastName LIKE '%''%'

  --Jonathan

  
  
  --Jonathan

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  October 21, 2003 at 3:34 pm

  #479007

  I glanced at REPLACE, and it didn't occur to me at the time that I could just use the 'LastName' field name in the first expression.

  Thanks for your help!

  CSDunn