Hello,
How is it possible to have field 3 below in json format and the rest of the fields as normal
for example this is the sql I use now to get the data but I would like to have the field4 in jason:
select
field1, field2, field3,
field4 = add1, add2, city
from tblMain
Thank you