Заменить 'г.' и другие типы гео-объектов на пустоту в поле prp.parcel_route_part_end_point_terminal_address_city. использовать select

SELECT
  CASE
    WHEN prp.parcel_route_part_end_point_terminal_address_city
    LIKE 'г. %' THEN SUBSTRING(prp.parcel_route_part_end_point_terminal_address_city,4)
    ELSE prp.parcel_route_part_end_point_terminal_address_city
  END
  AS "New_City"
FROM
  dbo.parcel_route_part AS prp