如何将国家，州和城市连接为国家 - >州 - >市 [英] How to concatename Country, state and city as Country -> State -> City

问题描述

我在表格中有3列。国家，州，城市。州和城市可以为空。我想将名为location的连接字段显示为：Country - >州 - >市。当州和城市可以为空时如何处理？

I have 3 columns in table. Country, State, City. Here State and City is nullable. I want to show concatenated field named location as: Country -> State -> City. How to handle this when state and city is nullable?

推荐答案

检查这个.. ..

Hi,

Check this....

Select ISNULL(COUNTRY,'') + '->' + ISNULL(STATE,'') + '->' + ISNULL(CITY,'') As Addr from your table

或

or

Select 
CASE WHEN ISNULL(COUNTRY,'')='' THEN '' ELSE COUNTRY END  + 
CASE WHEN ISNULL(STATE,'')='' THEN '' ELSE + '->' + STATE  END + 
CASE WHEN ISNULL(CITY,'')='' THEN '' ELSE + '->' + CITY END 
As Addr from your table

希望这会对你有所帮助。



干杯

Hope this will help you.

Cheers

这篇关于如何将国家，州和城市连接为国家 - >州 - >市的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！