If you are migrating data from one source to a SQL Server database, you would most likely bump into string containing apostrophes such as Jan ’10 etc. As you know, you would need to add another apostrophe in T-SQL such as ” in order for the data to pass through.
SELECT ‘Jan ”10’
To deal with this, use REPLACE() function. Replace one apostrophe with 2 apostrophes.
SELECT REPLACE(‘Jan ”10’,””,”””)