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 back 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