OK, I figured it out and see that you wouldn't have had enough info to answer anyway.  The issue with the query was a result of a data issue.  Some...

Many thanks to you both for replying.  @scdecade, it is valid json, but unfortunately I'm working with SQL 2012.

@desnorton, I'll give that a try today.  Again,...