如何在存储过程里实现让某字段值为空的时候替换为某字符如“no”，急问

[lilinew]

我的项目要求字段值为空的时候替换为某字符如“no”，大家指点我说可以在存储过程里实现让某字段值为空的时候替换为某字符如“no”。但是我不知道具体的写法，
请问如何写？？原来的存储过程如下（b.CurrentLoad ，c.ConnectionCount，需要实现字段值为空的时候替换为某字符如“no”。）
CREATE PROCEDURE XGetCluster
AS
SET NOCOUNT ON

select a.ScopeName, b.CurrentLoad As CurrentLoad,c.ConnectionCount As Con
nectionCount,a.MasterDispatcher As MasterDispatcher,a.SiteN
ame from XNetCluster As a,
XNetServer As b ,XNetRunTable As c where a.ScopeID = b.ScopeID AND a.SiteID
=c.SiteID

[dafu71]

CREATE PROCEDURE XGetCluster
AS
SET NOCOUNT ON

select a.ScopeName, isnull(b.CurrentLoad,'no') As CurrentLoad,isnull(c.ConnectionCount,'no') As Con
nectionCount,a.MasterDispatcher As MasterDispatcher,a.SiteN
ame from XNetCluster As a,
XNetServer As b ,XNetRunTable As c where a.ScopeID = b.ScopeID AND a.SiteID
=c.SiteID

[pengdali]

CREATE PROCEDURE XGetCluster
AS
SET NOCOUNT ON

select a.ScopeName, isnull(b.CurrentLoad,'no') as CurrentLoad,isnull(c.ConnectionCount,'no') As Con
nectionCount,a.MasterDispatcher As MasterDispatcher,a.SiteN
ame from XNetCluster As a,
XNetServer As b ,XNetRunTable As c where a.ScopeID = b.ScopeID AND a.SiteID
=c.SiteID

[lilinew]

myflok(阿棋) pengdali(大力 V2.0)
感谢csdn的朋友