Please help me to achieve the said out put. As for my data, I need both EPF Number & Emp fields to be with 6 digit lengths & as long as the length of the record remains less than 6 digits, I need zeros to make it 6 digit lengths.
Eg 3988 to be appeared as 003988 ,once data are loaded. The excel carries this length but once loaded it turns to be a number resulting all zeros getting dropped.
That's a neat one @vikramv
I usually do like this
Right('000000'& EPF, 6) as EPF,
Or like this if I know that EFT is an integer.
num(EPF, '000000') as EPF,