i did this
Help taken from kendash’s report
> min(substring(
> Cast(TE.EntityCustomData as nvarchar(4000)),
> CharIndex(’{“Name”:“Sector”,“Value”:"’,cast(TE.EntityCustomData as nvarchar(4000)))+26,
> CharIndex(’"’,cast(TE.EntityCustomData as nvarchar(4000)),
> CharIndex(’{“Name”:“Sector”,“Value”:"’,cast(TE.EntityCustomData as nvarchar(4000)))+26)
> - CharIndex(’{“Name”:“Sector”,“Value”:"’,cast(TE.EntityCustomData as nvarchar(4000)))-26)
> ) as [Sector]
YESSSSSSSSSSSS
THANK YOU GUYS