Taken directly from simple-talk.com; read more to see an excellent way to convert your stored SQL stored JSON string into a results table
You won’t benefit from indexing with this query (as you can in XML) but it will allow you to query JSON directly at the point of storage (one for the SQL developers than the web developers I guess!)