I just joined this site last week and I love it. 😀

This solution:

SELECT REPLACE(STR(somecol,6),' ','0')

by Jeff Moden

is just what I was looking for to (simply) export a column (adding leading...