Update query -- Help needed!!!!!

• gsvirdi

  SSC Veteran

  Points: 226

  More actions

  January 11, 2005 at 2:36 am

  #85047

  Hi All:

  I need to help to update a varchar data to remove an single quote; currently I my sing_on field contains data as below

  HelenO'Connor

  JudithO'Keeffe

  KevinO'Neill

  MichelleO'Doherty

  MatthewO'Connor

  MatthewO'Donnell

  I want to remove the single quote within the sign_on field. I was using the following UPDATE statement, but this didn't work

  UPDATE EMPLOYEE

  SET SIGN_ON = REPLACE('%'+CHAR(39)+'%','')

  Any help is highly appreciated.

  Thnx/Rgds,

• ~Sreejith G

  SSCrazy

  Points: 2311

  More actions

  January 11, 2005 at 3:12 am

  #536766

  Try This......

  UPDATE EMPLOYEE SET SIGN_ON  = REPLACE(SIGN_ON ,'''','')

  WHERE SIGN_ON  LIKE '%''%'

  Sree

   

   

• gsvirdi

  SSC Veteran

  Points: 226

  More actions

  January 11, 2005 at 4:45 am

  #536775

  Thanks Sree this worked for me.. 🙂