I’m trying to pull two columns (VendorName and VendorState) from the Vendors table using a UNION statement. How can I write the statement so that records with “NY” in VendorState show up as “NY”, but all other states show up as “Outside NY”. Thank you.
