@Loko @Reeza @FreelanceReinh Thank you all very much! The issue in my particular case was not with leading or trailing blanks but with an extra hidden space in between 'South' and 'Carolina'. Your examples were enlightening and should help me again in the future.
... View more