Search code examples
jasper-reports

jasper studio: truncating numbers in columns

enter image description hereenter image description here

How do you separate a number in a column (look at Publisheditemcode in the picture) where for an example 026.126572.1 becomes, as an output, 026.126572 when queried? this is in jasper studio version 6.3 i think or the latest version of jasper studio

Solution

  • The answer is as follows:

    SELECT SUBSTRING(your table name here,starting point,length) as "name", right(RTRIM(your table name here),length) as "name"

    from "table name"

    found on W3S school