How to parse value with JSON_VALUE when the string contains double quotes inside

99 Views Asked by At

I have a column called params which is a json data,

{
    "Sender": "Sean Simmons",
    "Event": "Annual meeting",    
    "EventDate": "2023-12-25",  
    "Message": "Attendance is "MANDATORY"!"
}

Trying to use JSON_VALUE on the column returns NULL, so i removed the quotes and then it worked, but is there anyway how i can handle this from the database to escape the double quotes of the value and to return it as it is?

Is there anything similar that i can use like the function escape_double_quotes to fix this issue?

0

There are 0 best solutions below