3 Replies Latest reply: Apr 20, 2015 9:19 AM by andy whitfield RSS

    Change number Format MySQL field

      Hello everybody,

      I am just starting the qlikview connection with a MySql DataBase and I've encountered my first problem which is giving me a hard time.


      This is my problem:


      I have this sequence of numbers:




      but I just need the first 8 numbers.


      As a qlikview script I used the following sentence:


      If(Len(number)=9,Left(number,8) as Number


      but with the MySql script I can't find a similar function.


      Can anybody help me?