Can you use SQL to SELECT values from a JSON array?
There's nothing natively, but the first answer on the follow question references an article about parsing JSON objects in tSQL
For reference, the article of interest is here:
http://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/
No (well, there's substring matching, but that would be slow and error-prone). If you're storing something you want to filter with SQL, do not use JSON, use separate columns/tables instead.