Skip to Content
Former Member
Mar 11, 2009 at 04:55 PM

Removing Leading zeros from query output.


Hello Experts,

Is it possible to remove leading zeros from the query output for a particular column?

I have a characteristics 'Reference Document' which has values like '000001386'. The users just need '1386' to be displayed and have asked us to remove the leading zeros.

Is there something that can be done for this at a query level? I can't modify the underlying InfoProvider because this requirement is just for one set of users, the other users need the document nmber in the original format.