DSXchange

adding a zero did not work, Substringing technique of course is succesfull, and about to try the FMT command.

Thanks for the help

I am having an issue after splitting a query into 2 ODBC stages that the result is now displaying -0.01 instead of -.01.

The same for 0.1 insead of .1

How can I remove the leading zero in front of the negative value as the TRIM is not working ???