QueryExample.sql

DECLARE @First TABLE
(
	[InstanceID] UNIQUEIDENTIFIER NOT NULL
);

DECLARE @Second TABLE
(
	[CogProgramOptions] VARCHAR(MAX) NOT NULL,
	[SomeOtherValue] INT NOT NULL
);

DECLARE @FirstId UNIQUEIDENTIFIER = NEWID();
DECLARE @SecondId UNIQUEIDENTIFIER = NEWID();

INSERT INTO @First ([InstanceID])
SELECT @FirstId;

INSERT INTO @Second ([CogProgramOptions], [SomeOtherValue])
SELECT
	CAST(@FirstId AS VARCHAR(38)) + ';' + CAST(@SecondId AS VARCHAR(38)), 100500;

SELECT
	[F].[InstanceID],
	[S].[SomeOtherValue]
FROM @First AS [F]
LEFT JOIN @Second AS [S] ON ([S].[CogProgramOptions] LIKE '%' + CAST([F].[InstanceID] AS VARCHAR(38)) + '%');