Incorrect syntax near 'Hanis'. Unclosed quotation mark after the character string ''.
exec Autos_GetZipCodeByStateAbbAndCity 'tx','D'Hanis'