SELECT ZipCode, CityStateName, StateAbbr FROM tbl_USPS_CityStateDetails WHERE ZipCode = AND CityStateKey = PreferredLastLineCityStateKey #cityStateName# #stateAbbr#