Steve-

>It's not easy to read and it's also hard to follow. All it does is insert leading zeroes so I can do a seek.

Boy. You're right. It's is hard to follow *bg*. I'm pretty clueless about the IF, but then, that's not part of your question.

I *think* this is what you want: PADL( ALLTRIM(STR( value ) ), 10, '0' )