Create random string

[Ivar]

Hi,

substring(newid(),0,8)

"Jason Davis" <jasondavis19@hotmail.com> wrote in message
news:uyGV9pFSDHA.1552@TK2MSFTNGP10.phx.gbl...

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

[Jason Davis]

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

[David Portas]

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

[Brad M.]

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

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

Regards,
Brad

"Jason Davis" <jasondavis19@hotmail.com> wrote in message
news:uyGV9pFSDHA.1552@TK2MSFTNGP10.phx.gbl...

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