Traditional Culture Encyclopedia - Hotel franchise - SQL statement query: Find out the city according to the address.

SQL statement query: Find out the city according to the address.

Select id and city from dbo. Trim (city) where TBL is located =' Dong Min Science and Technology Building, Qianfeng South Road, Taiyuan City, Shanxi Province 10 Floor 12'

Can't find it because there are spaces before and after the data in the city field.

-supplement.

It is out of the question. Some of you are not cities, but counties, and some are preceded by provincial names. You don't have a unified standard here, so it's hard to get it with stored procedures and simple sql.