请教在以下情况中如何实现筛选

case when bill_status ='P' then '部分到款' when  bill_status ='N' then '未到款' when  bill_status ='U' then '未发出' when  bill_status ='F' then '已到款' when  bill_status ='H' then '准到款' end AS 账单状态,
      

where 1=1 and j.num =1
  and ISNULL(bill_status,'') like '%[[[账单状态：<S>]]]%'

当前这个语句只能单一搜索账单状态 我想要实现可以同时搜索P，F…等等账单状态

and ISNULL(bill_status,'') like '%[[[账单状态：<S>]]]%'

请问该如何实现呢

and ISNULL(bill_status,'') like '%[[[账单状态：[<S>,<P>,<F>]]]%'

这样试试