Delete " how from Query:

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  December 29, 2008 at 4:13 am

  #129502

  one table and only one column I have.

  column has value: "ajay"

  "ram"

  "sanju"

  I want to delete "".

  I want column value: ajay

  ram

  sanju

  Thx..

  Thanks

• Carolyn Richardson

  SSCrazy Eights

  Points: 8357

  More actions

  December 29, 2008 at 4:30 am

  #918301

  try:-

  UPDATE tablename

  SET [fieldname] = REPLACE([fieldname],'"','')

  Facts are stubborn things, but statistics are more pliable - Mark Twain
  Carolyn
  SQLServerSpecialists[/url]