[thelist] Random value between 1 and x with SQL Server 2K

Warden, Matt mwarden at mattwarden.com
Sun Jul 29 21:42:04 CDT 2001


On Jul 29, Guy Babbitt had something to say about Re: [thelist] Random...

>I appreciate the other feedback.  Just for clarification, the reason I am using
>ceiling instead of floor or random is because those functions have the potential
>of returning a result of zero, which is not something I can use.

Not according to the docs, it can't:

"rand([integer])
 Returns a random float value between 0 and 1, using the optional integer
as a seed value"


--
mattwarden
mattwarden.com





More information about the thelist mailing list