Skip to content
Advertisement

Transform properties from JSON array into comma-separated string

I have a string column in an SQL-Server table on Azure which contains the following data:

How can it be transformed into a comma-separated string containing "Jane, John"?

Advertisement

Answer

Here how to achieve this via a snippet of some of my older code, you should be able to loop through the table and do this for each row. There may be a quicker way of doing it but this will work.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement