sestell1 (8/3/2012)
Interesting thread.
Well, in that case, here's another one. Only works on INT's >= 0.
SELECT
N,
LEFT(CAST(N % 10 AS CHAR(1)) +
CAST((N / 10) % 10 AS CHAR(1)) +
CAST((N / 100) % 10 AS CHAR(1)) +
CAST((N / 1000) % 10 AS CHAR(1)) +
CAST((N / 10000) % 10 AS CHAR(1)) +
CAST((N / 100000) % 10 AS CHAR(1)) +
CAST((N / 1000000) % 10 AS CHAR(1)) +
CAST((N / 10000000) % 10 AS CHAR(1)) +
CAST((N / 100000000) % 10 AS CHAR(1)) +
CAST((N / 1000000000) % 10 AS CHAR(1)), LEN(CAST(N AS VARCHAR(10))))
FROM
(
VALUES (521), (67342), (14), (4), (2111222333), (0), (4000)
) SampleData(N)