I have the following query that I am trying to modify to give me the correct results. Please see below
SELECT b.building_id, b.Display_Name, CASE WHEN b.City = 'Suburb - New York' THEN 'New York'
ELSE 'New York' END building_city,
FROM building b
WHERE b.City = 'New York'
AND b.[State] = 'NY'
ORDER by b.Display_Name
The problem is is only returns buildings that have an actual value of 'New York' for the city which is what I want, but I also want to say if the city has a value of 'Suburb - New York', then it should appear as well
I know "Suburb - New York" is not a city but I'm stuck working with the data this way so any help appreciated how I can modify my query.