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

exec Autos_GetZipCodeByStateAbbAndCity 'IL','AMF O'Hare'