title: MySQL's LPAD String Function in JPA Query?
body: <p>May I know how to convert the following MySQL SQL to JPA query?</p>
  
  <pre><code>SELECT * FROM ORDER
  WHERE LPAD(BATCH, 2, ' ') &lt; LPAD('X', 2, ' ') ;
  </code></pre>
  
  <p>What I couldn't figure out is the LPAD() string function in JPA.</p>
  
  <p>Do you have any idea?</p>