求帮助

[lakerskobemvp]

select 来源= (case when (t5.ispri&1 = 1) then '首页'
when (t5.ispri&2 = 2) then '发帖'
when (t5.ispri&4 = 4) then '新论坛'
when (t5.ispri&8 = 8) then '名博'
when (t5.ispri&16 = 16) then '问答'
when (t5.ispri&32 = 32) then '平媒'
when (t5.ispri&64 = 64) then '热门微博'
when (t5.ispri&1024 = 1024) then '手机新闻客户端'
when (t5.ispri&2048 = 2048) then '视频' end
如果有一个ispri既属于首页又属于发帖，但是只会加到首页部分，发帖部分没有，这种要怎么写

[--小F--]

t5.ispri&1 in (1,2) then '首页'

[Tiger_Zhao]

select 来源 = (CASE WHEN t5.ispri=0
                    THEN ''
                    ELSE SUBSTRING((case when (t5.ispri&1 = 1) then ',首页' else '' end) +
                                   (case when (t5.ispri&2 = 2) then ',发帖' else '' end) +
                                   (case when (t5.ispri&4 = 4) then ',新论坛' else '' end) +
                                   (case when (t5.ispri&8 = 8) then ',名博' else '' end) +
                                   (case when (t5.ispri&16 = 16) then ',问答' else '' end) +
                                   (case when (t5.ispri&32 = 32) then ',平媒' else '' end) +
                                   (case when (t5.ispri&64 = 64) then ',热门微博' else '' end) +
                                   (case when (t5.ispri&1024 = 1024) then ',手机新闻客户端' else '' end) +
                                   (case when (t5.ispri&2048 = 2048) then ',视频' else '' end)
                                  ,2
                                  ,100)
               END)