generate numbers based on input

DSguru2B · Post by **DSguru2B** » Thu Nov 17, 2005 5:30 pm

I have a column where the length of the field has to be 6. if it is less than 6, i have to keep the length of the field as 6 and add zeros on the remaining field.
I am checking the length of the field by the Len() function. but how to put that many zeros in that field. Can it be done within the transformer or i need to write a routine for it.
thanks guys.

chulett · Post by **chulett** » Thu Nov 17, 2005 5:59 pm

Please don't post the exact same question in multiple forums. This has already been answered over in the Server forum since this was a Server question.