Hi, I need JSON value from query string in table column it's possible ? CREATE TABLE #SUB1 (Ledger INT,Description VARCHAR(100)) CREATE TABLE #SUB2 (Ledger INT,Particulars VARCHAR(100)) INSERT INTO #SUB1 (Ledger,Description) VALUES (1001,'JOHN'),(1002,'ROBERT'),(1003,'JOE') INSERT INTO #SUB2 (Ledger,Particulars) VALUES (2001,'US'),(2002,'IND'),(2003,'DXB') CREATE TABLE #Main (ID INT,Name VARCHAR(50),QueryStr NVARCHAR(max)) INSERT INTO #Main (ID,Name,QueryStr) VALUES (1,'AAA','') ,(2,'BBB','') ,(3,'CCC','select Ledger,Description from #SUB1 for JSON PATH ') ,(4,'DDD','select Ledger,Particulars from #SUB2 for JSON PATH') select * from #Main drop table #Main,#SUB1,#SUB2 pls help.