When you try to use an insert statement in MSSQL and the string contains an apostrophe, such as:

insert into test_table set destinationfield = ‘Sometime’s’ where id = 1

Obviously test_table equals the table that holds the data, destinationfield equals the field in the table that is going to get updated, and id would equals the unique identifier of the row that is going to be changed. When you try and run this you will always get a SQL error. To get around this, you want to use double quotes:

insert into test_table set destinationfield = ‘Sometime”s’ where id = 1

You’ll notice that in the first example there is only one single quote at the end of the string. Just adding another single quote will allow the insert to go through.