title: universe U2.net SELECT wildcard
body: <p>When i use SQL to query MS access or MS SQL. I can have the following sql to retrieve data</p>
  
  <pre><code>SELECT ORDER_NO,NAME FROM ORDER WHERE LEFT(ORDER_NO,6)='123456'
  </code></pre>
  
  <p>to retrieve the record with order number start with '123456'</p>
  
  <p>But LEFT is not working in the Universe U2.net. </p>
  
  <p>What is do is below, but the query return result slow. </p>
  
  <pre><code>SELECT ORDER_NO,NAME FROM ORDER WHERE ORDER_NO LIKE '%123456%'
  </code></pre>
  
  <p>I am looking for alternative for , LEFT,MID and etc to optimize the code</p>
  
  <p>Thank you</p>