Hello
I have a column QT defined as varchar data type.
QT will be having values like
QT
12
124
89765
3456
......
QT could be of any length up to varchar(6).I need to map QT to QAT.
QAT should look like
QAT
000012
000124
089765
003456
QAT should be of 6 character length with zeros infront.
Any ideas will be appreciated.
Thanks
Conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Right("000000" : InLink.QT, 6)
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.