HI all,
I am using a stage variable to generate a sequence of numbers like 1,2 ,3 but in the output as 00000001, 00000002 .......... Can anyone help out in how to do this
Pad with Zeros
Moderators: chulett, rschirm, roy
You will need to convert the number to a string. A simple way would be to declare a VarChar(8) field and the derivatio of
Code: Select all
Right('00000000':In.StageVar,8)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom