Hello guys - Does anybody know if there is anyway to eliminate leading
zeros in SQL?

For example, if the SQL result is:

001 the SQL should produce only 1
If it is 010, it should produce 10
If it is 0100, it should produce 100?

Regards,
_________________
Mudassar Ather




DB2 & UDB email list listserv db2-l LazyDBA home page