how to create scalar value function for function split
Please let me know how to do.it i am new scalar valued function.
in table one column farmerdetailsdata record as follows
{"Produto preferido" :"Algodão","Plantou":"Sim"}
from the above i want output as follows
Produto preferido Algodão Plantou Sim
for this only i am writing a split function
i have one select in that select below query i want to call that function
SELECT A.farm_detailsdata,A.farmer_id,A.farmer_season,A.farm_visitno
FROM dbo.tbl_farmer_farmdetails A
INNER JOIN dbo.tbl_farmerregistration B ON B.farmerctscode = A.farmer_id
WHERE B.farmerseason = '2018'
for that how to split the function and call that function in my above select query
