JSON_VALUE in SQL-server 2014 I am looking for an equivalent functionalities of JSON_VALUE in SQL Server 2014. Can any of you post an alternate of the below code which is supported in SQL Server 2014

SELECT JSON_VALUE(ERROR_MSG, '$[0].applicationName') AS APPLICATION_NAME
FROM tablename


It errors out as below when run SQL 2014


  'JSON_VALUE' is not a recognized built-in function name.
JSON support was not introduced until SQL Server 2016, so you'll need to use custom functions. Check out Phil Factor's article on this where he provides some code for parsing JSON in earlier versions of SQL Server.