Archive for May, 2013

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’,””,”””)


Read Full Post »

%d bloggers like this: