title: how to take the first letters in Mysql request
body: <p>I have an <code>sql request</code>, that contains 3 parameters: </p>
  
  <pre><code>Article   Name_customer  id_customer.
  </code></pre>
  
  <p>My request is:</p>
  
  <pre><code>select "Article", "Client", "Name", round(sum("Montant_fac_eur")) as turnover
  from "foundry_sync"."data"
  where "Nature"='Repair' 
  
  and "annee" = {{w_widget24.selectedValue}}
  
  and extract(month from "Facturation") between 0+{{w_widget4.selectedValue}} and 2+{{w_widget4.selectedValue}}
  --and "Facturation" = {{w_widget6.selectedValue}}
  group by "Article", "Client", "Name"
  order by turnover DESC limit 5
  </code></pre>
  
  <p>I used the <code>id_customer</code> in the axis of abscissa, but I want change it by the name.
  The problem is the name of my customers are long.
  Can I do a test on the name to take just the 5 first letters, to display it in my dashboard ?</p>
  
  <p>PS.: Knowing that I have some names are similarly, looks like:</p>
  
  <pre><code>AEROSPARES 2000 LTD
  AEROSPARES SHANNON
  </code></pre>
  
  <p>Thanks </p>