在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屋！