title: Why do the % operators in the query not work for strings containing numbers? (JPA)
body: <p>I have the following query:</p>
  <pre><code> @Query(&quot;SELECT d FROM CarportLocationEntityView d WHERE d.externalId LIKE %:filterCriteria% OR lower(d.carportName) LIKE lower(concat('%',:filterCriteria,'%')) &quot;)
      List&lt;CarportLocationEntityView&gt; filterCarportList(@Param(&quot;filterCriteria&quot;) String filterCriteria);
  </code></pre>
  <p>This query searches two columns in the database:</p>
  <ol>
  <li>externalId</li>
  <li>carportName</li>
  </ol>
  <p>Both columns are of type string, where in externalId always a number is specified as string. if I apply the query and enter a part of carportName then I get the correct results.
  However, if I filter for an externalId and enter only a part of the externalId in the parameter then I get no data.</p>
  <p>Ex: localhost:8080/filter?filterCriteria=100
  Here I get no data back.</p>
  <p>But if I filter for the whole externalId
  localhost:8080/filter?filterCriteria=1000000
  then I get the matching data set.</p>
  <p>Why do the % operators in the query not work for strings containing numbers?</p>