3 Replies Latest reply: Apr 20, 2015 9:19 AM by Andrew Whitfield RSS

    Change number Format MySQL field

    Francisco Acuna

      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:

       

      123456789

       

      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?