Thanks Jeff, good to know. I personally have always used this syntax: REPLICATE('0',10-LEN(SomeNumber)) + CAST(somenumber AS VARCHAR(10)), which has always worked well for me, but appears to be slightly...