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

exec RE_GetZipCodeByStateAbbreviationAndCity 'or','O'Brien'