SQLTeam.com | Weblogs | Forums

Remove " in a column

hi experts,
I need to update a column that has " to remove those chars double quotes
I tried the code below but it didn't remove the ". What am I doing wrong? Thanks

UPDATE [dbo].[Table]

SET [Column] = Replace(Column, '”', '')

Make sure it's not a "smart" quote.

SET [Column] = Replace(Column, '"', '')

1 Like

Thanks Scott. This is what I ended up using before you posted. It worked