Home Forums SQL Server 2005 SQL Server Newbies Random 64 Characters alphanumeric String RE: Random 64 Characters alphanumeric String

  • March 11, 2009 at 10:42 pm

    #958068

    select

    Random_String =

    substring(x,(abs(checksum(newid()))%36)+1,1)+

    substring(x,(abs(checksum(newid()))%36)+1,1)+

    substring(x,(abs(checksum(newid()))%36)+1,1)+

    substring(x,(abs(checksum(newid()))%36)+1,1)+

    /* and so on for as many characters as needed */

    substring(x,(abs(checksum(newid()))%36)+1,1)

    from

    (select x='0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ') a

    Results:

    Random_String

    -------------

    T7TAR