• 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)