如何把select语句中得到的null值替换成其它字符

select * from V_opration

number     opration     pubname   proname  expname
-----------------------------------------------------------
1                Add         admin          null          null
2                del           admin          null           null
3                res           null              IBM         null
4                give         null               null           A1

把后面三列合并:
select number,opration,coalesce(pubname,'')+coalesce(proname,'')+coalesce(expname,'')
as OPNAME  from V_opration

转载于:https://www.cnblogs.com/muying/archive/2007/01/15/620623.html