Thank You - you are all awesome

Ive also tried

SELECT top 1000 [cp_initialreviewId]

,[cp_AssessmentChannelOptions]

,(SELECT [ChannelName]

FROM OPENJSON(cp_AssessmentChannelOptions)

WITH (ChannelName NVARCHAR(50) '$.ChannelName'))

,(SELECT [Removed]

FROM OPENJSON(cp_AssessmentChannelOptions)

WITH (Removed BIT '$.Removed'))

FROM [PIP_MSCRM_MI_DB].[dbo].[cp_initialreviewBase]

But I get the error

Subquery returned more than 1 value. This is not permitted...

That is truly fantastic and going to save me so many headaches,

one last question I promise, can I turn this into a function where I pass it the field from...

Hi, thanks for replying. its 50% of the way there. splits out my uniqueidentifier perfectly.

I however, also need the false or true part that relates to each identifier, so in...