select NULL + "abc"

[gauss]

select NULL + "abc"

现在的结果是NULL，

怎样才能得到"abc"?

[fengfangfang]

select NULL + "abc" 就是null

[fengfangfang]

如果用列可以
select IsNull(colname,'') + 'abc'

[zjcxc]

select isnull(NULL,"") + "abc"

[paoluo]

Select IsNull(Null,'') + 'abc'
Or
Select IsNull(ColName,'') + 'abc' from TableName

[xluzhong]

declare @a table (col nvarchar(10) null)
insert into @a select 'test' union all select null

select IsNull(col,'')+'abc'
from @a