select a,b,isnull(c,'家家 ') from A
select a,b,'c'=(case when c is null then '家家' else cast(c as varchar(100)) end) from tablename
[已结贴,结贴人:netqq100]
