Double quotes replacement - Microsoft SQL Server
Double quotes replacement. Microsoft SQL Server Forums on Bytes. ... how to replace all the double quotes (") within the following sentence (or a column) with single quotes ('), ... You need to specify 2 single quotes within the literal string when 1 quote is desired. Try: Select Replace(colA,'"','''') From tblXYZ--Hope this helps.
DA: 29 PA: 75 MOZ Rank: 63