Incorrect syntax near 's'. Unclosed quotation mark after the character string ''.

exec Autos_GetZipCodeByStateAbbAndCity 'IL','Lincoln's New Salem'