在sql 2008中将3列组合为单个列 [英] Combining 3 columns as a single column in sql 2008
问题描述
嗨专家,
BM_Address_Eng1 BM_Address_Eng2      BM_Address_Eng3 BM_Address_pin
G / O SOSAWWA G HULIKATTI VILLAGE-      KALGHATGI TALUK 574101
如何将这些列组合到一个地址栏
like
地址
G / O SOSAWWA G HULIKATTI VILLAGE- KALGHATGI TALUK 574101
请帮助我获得上述输出。
这里有时BM_Address_Eng2可能具有空值。
感谢你
(Keerthi Kumar)
Hi experts,
BM_Address_Eng1 BM_Address_Eng2 BM_Address_Eng3 BM_Address_pin
G/O SOSAWWA G HULIKATTI VILLAGE- KALGHATGI TALUK 574101
how to combine these columns to a single address column
like
Address
G/O SOSAWWA G HULIKATTI VILLAGE- KALGHATGI TALUK 574101
Please help me to get the output as mentioned above.
Here sometimes BM_Address_Eng2 may be having null value.
Thanking You
(Keerthi Kumar)
推荐答案
问题在于在' BM_Address_Eng2可能有空值。',所以试试这个:
The problem lies in 'BM_Address_Eng2 may be having null value.', so try this:
select BM_Address_Eng1 + isnull(BM_Address_Eng2, '') + BM_Address_Eng3 + BM_Address_pin
from table1;
select(column1 +','+ column2 +','+ column3 +','+ column4)作为表中的地址
否则转到连接
select (column1+', '+column2+' ,'+column3+','+column4)as address from table
else go for Concatenate
就像输出一样,如果你需要在每一列之间留一些空格,那么在上面的查询中几乎没有修改
选择BM_Address_Eng1 +''+ isnull(BM_Address_Eng2,'')+''+ BM_Address_Eng3 +''+ BM_Address_pin
;
Just like your output if you need some spaces between each column, then little modification in above query
select BM_Address_Eng1 +' ' + isnull(BM_Address_Eng2, '') +' ' + BM_Address_Eng3 +' ' + BM_Address_pin
from table1;
这篇关于在sql 2008中将3列组合为单个列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!