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

exec Autos_GetZipCodeByStateAbbAndCity 'il','AMF O'Hare'