SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE CbahiHSSpecialtyUnits(Units TEXT, HsSubStandardID INT, SpecialtyID INT)
✓
INSERT INTO CbahiHSSpecialtyUnits VALUES
('6,7,8,9,10,11,12,13,14,15,16', 22, 2)
✓
WITH cte AS (
  SELECT SUBSTR(Units, 1, INSTR(Units || ',', ',') - 1) col,
         SUBSTR(Units, INSTR(Units || ',', ',') + 1) value
  FROM CbahiHSSpecialtyUnits
  WHERE HsSubStandardID=22 AND SpecialtyID = 2
  UNION ALL
  SELECT SUBSTR(value, 1, INSTR(value || ',', ',') - 1),
         SUBSTR(value, INSTR(value || ',', ',') + 1)
  FROM cte
  WHERE LENGTH(value) > 0
)
SELECT col 
FROM cte
WHERE col + 0 > 0


col


6

7

8

9

10

11

12

13

14

15

16


WITH cte AS (SELECT 1 col UNION ALL SELECT col + 1 FROM cte WHERE col < 20)
SELECT c.col 
FROM cte c INNER JOIN CbahiHSSpecialtyUnits u
ON ',' || u.Units || ',' LIKE '%,' || c.col || ',%'
WHERE HsSubStandardID=22 AND SpecialtyID = 2


col


6

7

8

9

10

11

12

13

14

15

16