case
        when ([address]~="tp. hcm") OR ([address]~="hcm") OR ([address]~="ho chi minh") then "Hồ Chí Minh City"
        when ([address]~="ha noi") OR ([address]~="ha no") or ([address]~="hn")
                OR ([address]~="Bkav") OR ([address]~="Vinhome Central Park")
                OR ([address]~="hanoi") then "Hà Nội"
        when [address]~="an giang" then "An Giang"
        when [address]~="ba ria - vung tau" then "Bà Rịa - Vũng Tàu"
        when [address]~="bac giang" then "Bắc Giang"
        when [address]~="bac kan" then "Bắc Kạn"
        when [address]~="bac lieu" then "Bạc Liêu"
        when [address]~="bac ninh" then "Bắc Ninh"
        when [address]~="ben tre" then "Bến Tre"
        when [address]~="binh dinh" then "Bình Định"
        when [address]~="binh duong" then "Bình Dương"
        when [address]~="binh phuoc" then "Bình Phước"
        when [address]~="binh thuan" then "Bình Thuận"
        when [address]~="ca mau" then "Cà Mau"
        when [address]~="can tho" then "Cần Thơ"
        when [address]~="cao bang" then "Cao Bằng"
        when ([address]~="da nang") or ([address]~="Đà nẵng") then "Đà Nẵng"
                when [address]~="dak lak" then "Đak Lăk"
        when [address]~="dak nong" then "Đắk Nông"
        when [address]~="dien bien" then "Điện Biên"
        when ([address]~="dong nai") or ([address]~="đồng nai") then "Đồng Nai"
        when [address]~="dong thap" then "Đồng Tháp"
        when ([address]~="gia lai") or ([address]~="gia lai") then "Gia Lai"
        when [address]~="ha giang" then "Hà Giang"
        when [address]~="ha nam" then "Hà Nam"
        when [address]~="ha tinh" then "Hà Tĩnh"
        when [address]~="hai duong" then "Hải Dương"
        when [address]~="hai phong" then "Hải Phòng"
        when [address]~="hau giang" then "Hậu Giang"
        when [address]~="hoa binh" then "Hòa Bình"
        when [address]~="hung yen" then "Hưng Yên"
        when [address]~="khanh hoa" then "Khánh Hòa"
        when [address]~="kien giang" then "Kiên Giang"
        when [address]~="kom tum" then "Kon Tum"
        when [address]~="lai chau" then "Lai Châu"
        when [address]~="lam dong" then "Lâm Đồng"
        when [address]~="lang son" then "Lạng Sơn"
        when [address]~="lao cai" then "Lào Cai"
        when [address]~="long an" then "Long An"
        when [address]~="nam dinh" then "Nam Định"
        when [address]~="nghe an" then "Nghệ An"
        when [address]~="ninh binh" then "Ninh Bình"
        when [address]~="ninh thuan" then "Ninh Thuận"
        when [address]~="phu tho" then "Phú Thọ"
        when [address]~="phu yen" then "Phú Yên"
        when [address]~="quang binh" then "Quảng Bình"
        when [address]~="quang nam" then "Quảng Nam"
        when [address]~="quang ngai" then "Quảng Ngãi"
        when [address]~="quang ninh" then "Quảng Ninh"
        when [address]~="quang tri" then "Quảng Trị"
        when [address]~="soc trang" then "Sóc Trăng"
        when [address]~="son la" then "Sơn La"
        when [address]~="tay ninh" then "Tây Ninh"
        when [address]~="thai binh" then "Thái Bình"
        when [address]~="thai nguyen" then "Thái Nguyên"
        when [address]~="thanh hoa" then "Thanh Hóa"
        when [address]~="thua thien hue" then "Thừa Thiên Huế"
        when [address]~="tien giang" then "Tiền Giang"
        when [address]~="tra vinh" then "Trà Vinh"
        when [address]~="tuyen quang" then "Tuyên Quang"
        when [address]~="vung tau" then "Vũng Tàu"
        when [address]~="vinh long" then "Vĩnh Long"
        when [address]~="vinh phuc" then "Vĩnh Phúc"
        when [address]~="yen bai" then "Yên Bái"
        else ""
end