title: SQL LIKE query on JSON data
body: <p>I have JSON data (no schema) stored in a SQL Server column and need to run search queries on it.</p>
  
  <p>E.g. (not actual data)</p>
  
  <pre><code>[
   {
     "Color":"Red",
     "Make":"Mercedes-Benz"  
   },
   {
     "Color":"Green",
     "Make":"Ford"  
   },
  ]
  </code></pre>
  
  <p>SQL Server 2017 has JSON_XXXX methods but they work on pre-known schema. In my case, the schema of objects is not defined precisely and could change. </p>
  
  <p>Currently to search the columns e.g. find Make=Mercedes-Benz. I'm using a search phrase "%\"Make\":\"Mercedes-Benz\"%". This works quite well IF exact make name is used. I'd like user to be able to search using partial names as well e.g. just typing 'Benz' or 'merc'. </p>
  
  <p>Is it possible to structure a SQL query using wild cards that'll work for me? Any other options? </p>