Conversion

dodda · Post by **dodda** » Mon Feb 18, 2008 3:38 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Feb 18, 2008 3:51 pm

Code: Select all

Right("000000" : InLink.QT, 6)

dodda · Post by **dodda** » Mon Feb 18, 2008 4:06 pm

thanks ray that solved my problem