how can i find length of json object in sql server 2016? : [{"FUNCTION_HIERARCHY_LEVEL":"1","FUNCTION_PRIMARY_INDICATOR":"1","FUNCTION_CODE":"16041049","FUNCTION_DESCRIPTION":"SERVICES","FUNCTION_GLOBAL_CODE":"163554","FUNCTION_GLOBAL_DESCRIPTION":"Internal Services","Function_TYPE":"bbcc","FUNCTION_TYPE_CODE":"ASSIGNED","FUNCTION_TYPE_DESCRIPTION":"Assigned to the Function"},{"FUNCTION_HIERARCHY_LEVEL":"2","FUNCTION_PRIMARY_INDICATOR":"1","FUNCTION_CODE":"16041049","FUNCTION_DESCRIPTION":"SERVICES","FUNCTION_GLOBAL_CODE":"1736","FUNCTION_GLOBAL_DESCRIPTION":"Information Technology","Function_TYPE":"bb","FUNCTION_TYPE_CODE":"ASSIGNED","FUNCTION_TYPE_DESCRIPTION":"Assigned to the Function"},{"FUNCTION_HIERARCHY_LEVEL":"1","FUNCTION_PRIMARY_INDICATOR":"1","FUNCTION_CODE":"16041049","FUNCTION_DESCRIPTION":"SERVICES","FUNCTION_GLOBAL_CODE":"163554","FUNCTION_GLOBAL_DESCRIPTION":"Internal Services","Function_TYPE":"bbcc","FUNCTION_TYPE_CODE":"HE","FUNCTION_TYPE_DESCRIPTION":"Client Service Function Assigned by HR"},{"FUNCTION_HIERARCHY_LEVEL":"2","FUNCTION_PRIMARY_INDICATOR":"1","FUNCTION_CODE":"16041049","FUNCTION_DESCRIPTION":"SERVICES","FUNCTION_GLOBAL_CODE":"1736","FUNCTION_GLOBAL_DESCRIPTION":"Information Technology","Function_TYPE":"bb","FUNCTION_TYPE_CODE":"HE","FUNCTION_TYPE_DESCRIPTION":"Client Service Function Assigned by HR"}]

how can i find length of this json in sql if this value is stored in json column in some table?

