SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t(i INT, c VARCHAR(10));
INSERT INTO t(i,c) VALUES(1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e')
5 rows affected

SELECT * FROM t;


i
c


1
a

2
b

3
c

4
d

5
e


SELECT STRING_AGG(c,(CASE WHEN i%2=0 THEN ' OR ' ELSE ' AND ' END)) WITHIN GROUP (ORDER BY i) AS r
FROM t;
Msg 8733 Level 16 State 1 Line 1
Separator parameter for STRING_AGG must be a string literal or variable.

SELECT STRING_AGG(c+(CASE WHEN i%2=0 THEN ' OR ' ELSE ' AND ' END), '') WITHIN GROUP (ORDER BY i) AS r
FROM t;


r


a AND b OR c AND d OR e AND


-- removing last separator
WITH cte AS (
  SELECT STRING_AGG(c+(CASE WHEN i%2=0 THEN ' OR ' ELSE ' AND ' END), '')
       WITHIN GROUP (ORDER BY i)AS r
  FROM t
)
SELECT r, REPLACE(REPLACE(r+'$', ' OR $', ''), ' AND $', '') AS r
     ,STUFF(r,
         LEN(r)-CHARINDEX(' ', REVERSE(TRIM(r)))+1, 
         CHARINDEX(' ', REVERSE(TRIM(r)))+1,
         '') AS r
FROM cte


r
r
r


a AND b OR c AND d OR e AND
a AND b OR c AND d OR e
a AND b OR c AND d OR e