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, '”', '')
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, '"', '')