Professional Web Applications Themes

Create random string - Microsoft SQL / MS SQL Server

Hi, substring(newid(),0,8) "Jason Davis" <jasondavis19hotmail.com> wrote in message news:uyGV9pFSDHA.1552TK2MSFTNGP10.phx.gbl... > How can I create a random (not necessarily unique) - 8 character string? > Thanks! > >...

  1. #1

    Default Re: Create random string


    Hi,

    substring(newid(),0,8)

    "Jason Davis" <jasondavis19hotmail.com> wrote in message
    news:uyGV9pFSDHA.1552TK2MSFTNGP10.phx.gbl...
    > How can I create a random (not necessarily unique) - 8 character string?
    > Thanks!
    >
    >

    Ivar Guest

  2. #2

    Default Create random string

    How can I create a random (not necessarily unique) - 8 character string?
    Thanks!


    Jason Davis Guest

  3. #3

    Default Re: Create random string

    > substring(newid(),0,8)
    Doesn't work: "The data type uniqueidentifier is invalid for the substring
    function."

    This is OK though:
    SELECT LEFT(CAST(NEWID() AS VARCHAR(36)),8)

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --



    David Portas Guest

  4. #4

    Default Re: Create random string

    Here is code for a SP that generates a random string:

    [url]http://vyaskn.tripod.com/code/password.txt[/url]

    Regards,
    Brad

    "Jason Davis" <jasondavis19hotmail.com> wrote in message
    news:uyGV9pFSDHA.1552TK2MSFTNGP10.phx.gbl...
    > How can I create a random (not necessarily unique) - 8 character string?
    > Thanks!
    >
    >

    Brad M. Guest

Similar Threads

  1. Create string from vars
    By flasheister in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: August 8th, 09:43 PM
  2. Create a random number (ASP VBScript)
    By CharlyAR in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: July 15th, 11:06 PM
  3. create a random password?
    By woodywyatt in forum Dreamweaver AppDev
    Replies: 3
    Last Post: April 11th, 08:24 PM
  4. Replies: 2
    Last Post: August 16th, 10:26 AM
  5. substitute three random words in a string
    By Purl Gurl in forum PERL Miscellaneous
    Replies: 4
    Last Post: August 13th, 08:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139