hi i have input fields like
49456.07
The output i need is
00049456
i tried by using
left('00000000': left(select_stats.TRN_VOLUME_COUNT2,6),8).
Giving me results
00000000
i need 00049456
The length of column is varchar(8))
Can you please help me on this
concatenate zeros to fields
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Right(Str("0",8):Field(InLink.TheString,".",1,1),8)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.