喜欢用NULLIF和ISNULL。呵呵
DECLARE @a TABLE(x bit)
INSERT @a SELECT 1 UNION ALL SELECT 0 UNION ALL SELECT 1
SELECT x,ISNULL(STUFF(RTRIM(NULLIF(x,1))+'为0时我显示',1,1,''),'为1时我显示') FROM @a
Declare @t table(Content varchar(800),caption varchar(50),AAA bit,pkid int)
Insert @t select 'aaa','ddd',0,1
Union all select 'bbb','eee',1,2
Union all select 'ccc','ttt',0,2
--------------
Select case when AAA=0 then '字段AAA为0时的字符串' else '字段AAA为1时的字符串' end as 字符串
From @t