title: Can you use SQL to SELECT values from a JSON array?
body: <p>I have a database in SQL Server 2008 and one particular table has information stored in fields as JSON-encoded arrays.  I'm wondering there's a SQL-based approach to select out specific values within that JSON field?</p>
  
  <p>I can, of course, just select the field and parse the information out myself, but I'm trying to avoid that if at all possible.</p>
  
  <p>Thanks in advance!</p>