title: multiple Like expression in sql query using case exprssion
body: <p>I have query written below.</p>
  
  <pre><code>SELECT T1.[AcctCode],T1.[Segment_0],SUM(T0.[DebLTotal]) AS BUDGET, SUM(T3.[Debit]) AS DEBIT,
         AcctName = CASE WHEN T1.[Segment_0] LIKE '6001%%' THEN 'Operating Cost' 
                         WHEN T1.[Segment_0] LIKE '6002%%' THEN 'Operating Cost'
                         WHEN T1.[Segment_0] LIKE '6003%%' THEN 'Operating Cost'
                         WHEN T1.[Segment_0] LIKE '6004%%' THEN 'Operating Cost'
                         WHEN T1.[Segment_0] LIKE '6005%%' THEN 'Operating Cost'
                         WHEN T1.[Segment_0] LIKE '6006%%' THEN 'Operating Cost'
           ELSE T1.[AcctName] END
  FROM OBGT T0 INNER JOIN OACT T1 ON T0.[AcctCode]=T1.[AcctCode] INNER JOIN OBGS T2 
  ON T0.[Instance] = T2.[AbsId] INNER JOIN JDT1 T3 ON T1.[AcctCode] = T3.[Account] INNER JOIN OASC T4 ON T1.[Project]=T4.[Code] 
  where T1.[Segment_0] like '60%%'
  GROUP BY T1.[AcctCode],T1.[Segment_0],T1.[AcctName]
  </code></pre>
  
  <p>This query gives me different values for operating cost. I need something like <code>WHEN T1.[Segment_0] LIKE '6002%%,6003%%,6004%%' THEN 'Operating Cost'</code>. Is it possible? I don't need different likes by one by one. I need all in one as operating cost. Please help me out for this.</p>