--Initialize
DECLARE @temptable TABLE(
  [Contract] int,
  PH varchar(20),
  [Status] varchar(20),
  MonAM varchar(200),
  MonPM varchar(200),
  WkComm date);

INSERT INTO @temptable VALUES
  (99408, 'Contract1', 'Live', 'Op1 Op2 Op4 Op7 Op11', 'Op1 Op2 Op4', '2014-01-06'),
  (99779, 'Contract2', 'Hold', 'Op1 Op2', 'Op1', '2014-01-06'),
  (99791, 'Contract3', 'Live', 'Op6 Op7 Op9', 'Op6 Op7 Op9', '2014-01-06'),
  (99967, 'Contract4', 'Live', 'Op1', 'Op11', '2014-01-06'),
  (99985, 'Contract5', 'Hold', 'Op8', 'Op5', '2014-01-06'),
  (99992, 'Contract6', 'Live', 'Op5', 'Op13', '2014-01-06');

DECLARE @condition TABLE(
  Names varchar(20));

INSERT INTO @condition VALUES
  ('Op1'),
  ('Op2'),
  ('Op3'),
  ('Op4'),
  ('Op5');

--Regularize in CTE
WITH REGULARIZED_AM([Contract], MonAM, MonAMWork) AS (
SELECT
  [Contract],
  SUBSTRING(MonAM, 0, CHARINDEX(' ', MonAM + ' TERMINATER', 0)),
  CONVERT(varchar(200), SUBSTRING(MonAM, CHARINDEX(' ', MonAM, 0) + 1, LEN(MonAM) - CHARINDEX(' ', MonAM, 0)) + CASE WHEN 0 < CHARINDEX(' ', MonAM, 0) THEN ' TERMINATER' END)
FROM @temptable
UNION ALL
SELECT
  [Contract],
  SUBSTRING(MonAMWork, 0, CHARINDEX(' ', MonAMWork, 0)),
  SUBSTRING(MonAMWork, CHARINDEX(' ', MonAMWork, 0) + 1, LEN(MonAMWork) - CHARINDEX(' ', MonAMWork, 0))
FROM REGULARIZED_AM
WHERE 0 < CHARINDEX(' ', MonAMWork, 0)
),
REGULARIZED_PM([Contract], MonPM, MonPMWork) AS (
SELECT
  [Contract],
  SUBSTRING(MonPM, 0, CHARINDEX(' ', MonPM + ' TERMINATER', 0)),
  CONVERT(varchar(200), SUBSTRING(MonPM, CHARINDEX(' ', MonPM, 0) + 1, LEN(MonPM) - CHARINDEX(' ', MonPM, 0)) + CASE WHEN 0 < CHARINDEX(' ', MonPM, 0) THEN ' TERMINATER' END)
FROM @temptable
UNION ALL
SELECT
  [Contract],
  SUBSTRING(MonPMWork, 0, CHARINDEX(' ', MonPMWork, 0)),
  SUBSTRING(MonPMWork, CHARINDEX(' ', MonPMWork, 0) + 1, LEN(MonPMWork) - CHARINDEX(' ', MonPMWork, 0))
FROM REGULARIZED_PM
WHERE 0 < CHARINDEX(' ', MonPMWork, 0)
)
--Substitute 'FOR XML' for group_concat
SELECT
  BASE.Contract,
  BASE.PH,
  BASE.Status,
  ISNULL((
    SELECT
    MonAM + ' '
    FROM REGULARIZED_AM
    WHERE EXISTS(
      SELECT
        *
      FROM @condition
      WHERE REGULARIZED_AM.MonAM = Names)
    AND BASE.[Contract] = REGULARIZED_AM.[Contract]
    FOR XML PATH('')
  ), '') AS MonAM,
  ISNULL((
    SELECT
    MonPM + ' '
    FROM REGULARIZED_PM
    WHERE EXISTS(
      SELECT
        *
      FROM @condition
      WHERE REGULARIZED_PM.MonPM = Names)
    AND BASE.[Contract] = REGULARIZED_PM.[Contract]
    FOR XML PATH('')
    ), '') AS MonPM,
  BASE.WkComm
FROM @temptable BASE