sql 合并字段

[cgjxcq]

有一个表：table
表头: A,b,c,d,e,f,g
数据: a, ,e,6,k,x,n
数据: a,b,f, ,k,n,n
数据: p,b,e,k, ,x,n
数据: x, ,e,6,k,x,n
.......


请问一下大家，我要合并所有的字段 A,b,c,d,e,f,g


selst A+b+c+d+e+f+g as name form table

但是，每个表中都有为NULL的字段，所以查询出来的结果，全部为空白，请问一下怎样把空白的字段都合并！
在网上找了好多方法，就是用IF 去判断 is null 和is not null 但小弟不懂！请教大家！

[wanhot]

isNull（），是解决方案，其实还有别的……

[liangCK]

ISNULL(a,'')+ISNULL(b,'')+ISNULL(c,'')

[htl258_Tony]

selst isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') as name form [table] 

[csdyyr]

selst 
isnull(A,'')+
isnull(B,'')+
isnull(C,'')+
isnull(D,'')+
isnull(E,'')+
isnull(F,'')+
isnull(G,'') as name 
form table 

[Zoezs]

selst isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') as name form [table] 

[dj3688]

[CODE=SQL]
selest isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') as name form [table]
[/SQL]

[让你望见影子的墙]

selst col=isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') form tb

[htl258_Tony]

汗，跟着楼主写错两个关键字。

select isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') as name from [table] 

[dj3688]

[CODE=SQL]
select isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') as name form [table]
[/CODE]

[ai_li7758521]

ISNULL ( check_expression , replacement_value )
如果 check_expression 不为 NULL，则返回它的值；
否则，在将 replacement_value 隐式转换为
check_expression 的类型（如果这两个类型不同）后，则返回前者。

[dj3688]

[Quote=引用 8 楼 htl258 的回复:]
汗，跟着楼主写错两个关键字。


SQL codeselect isnull(A,'')+isnull(b,'')+isnull(c,'')+isnull(d,'')+isnull(e,'')+isnull(f,'')+isnull(g,'') as name from [table]
[/Quote]

up

[caohao]

selst
isnull(A,'')+
isnull(B,'')+
isnull(C,'')+
isnull(D,'')+
isnull(E,'')+
isnull(F,'')+
isnull(G,'') as name
form table