Thanks both .it works.

I have start date but want to get rest of columns in my table. I have attached consumable script above.

Thanks.both worked.

Both of these query not giving me correct result when there are NULLs.

can anyone help with the same. thanks in advance.

Thanks but i get blank column when i run above. Format of my column looks like below-

[{"Id":1725,"Number":"12345","quantity":1,"Block":true},{"Id":125,"Number":"1234544","quantity":1,"Block":true}]

i ran the function in the above link. I want to pass table into the function but it looks like i am doing it wrong-

Please suggest.

SELECT...

Thank you Phil and sgmunson. I will try XML stuff.