Sometimes I just can't see the solutions even when it's right in front of me. Never thought of using a union. or a compound operator.

One question is the output displays row 10 twice,

Address_pkAddressAddressAbbreviated

101400 Court Place1400 Court PL

101400 Court Place1400 CT Place

I only want the first one. I'm hoping you have an equally slick way to remove the 2nd result from this listing!