FORMAT returns NULL for errors other than a culture that isn't valid. For example, NULL is returned if the value specified in format isn't valid. The FORMAT function is nondeterministic. FORMAT relies ...

However, even without a JSON datatype, SQL Server 2016 still lets you query data stored in JSON format. I’ll look at that support in a later column (among other features, it provides a way to ...