Strange Behavior on JSON_VALUE When Table Contains Blank and Non-blank Values (JSON Text is Not Properly Formatted. Unexpected Character ‘.’ is Found at Position 0.)

(Manjuke Fernando) Few days ago, we had a requirement to search whether a certain value exists in one of the table fields where the values are stored as JSON strings.

Register to Read