https://community.qlik.com/t5/Talend-Studio/Why-lose-zero-when-convert-string-to-big-decimal/m-p/2368079#M131383 Leading zeroes are not stored in numeric data types. &nbsp;If you need them for display purposes, there are formatting functions you can use, but if you need them for comparison purposes, you'll have to stick to strings. Wed, 26 Oct 2016 19:53:26 GMT cterenzi 2016-10-26T19:53:26Z https://community.qlik.com/t5/Talend-Studio/Why-lose-zero-when-convert-string-to-big-decimal/m-p/2368078#M131382 <P>Hello,<BR /><BR />I have a probleme with convertion String.<BR />In fact i would like to convert a string 022451547.<BR />The result with method "new BigDecimal" is 22451547. I lose a zero in begin.<BR />I search in google and talend forum but I have not found.<BR />Have you a solution ?<BR />Thanks in advance,</P> Wed, 26 Oct 2016 17:48:24 GMT https://community.qlik.com/t5/Talend-Studio/Why-lose-zero-when-convert-string-to-big-decimal/m-p/2368078#M131382 Anonymous 2016-10-26T17:48:24Z https://community.qlik.com/t5/Talend-Studio/Why-lose-zero-when-convert-string-to-big-decimal/m-p/2368079#M131383 Leading zeroes are not stored in numeric data types. &nbsp;If you need them for display purposes, there are formatting functions you can use, but if you need them for comparison purposes, you'll have to stick to strings. Wed, 26 Oct 2016 19:53:26 GMT https://community.qlik.com/t5/Talend-Studio/Why-lose-zero-when-convert-string-to-big-decimal/m-p/2368079#M131383 cterenzi 2016-10-26T19:53:26Z