Random number between 10000000 and 99999999 in Stored procedure

Posted in 2000

jenderka@my-deja.com — Wed, 06 Sep 2000 07:47:29 GMT — source: Informix-list mailing list archive (1991-1998)

How could I obtain a random number between 10000000 and a upper limit 99999999. I need to generate these numbers in Stored procedure. -- Jenderka Vlastimil jenderka@post.cz Have a nice day! Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to jenderka@my-deja.com

Robert Stuart — Wed, 6 Sep 2000 13:57:42 +0100 — source: Informix-list mailing list archive (1991-1998)

Look at http://www.iiug.org/members/memb_software/archive/random_spl, it's by Jonathan Leffler. You'll have to adapt the range, (maybe with multiple calls?) <jenderka@my-deja.com> wrote in message news:8p4sqd$o4t$1@nnrp1.deja.com... > How could I obtain a random number > between 10000000 and a upper limit 99999999. > > I need to generate these numbers in Stored procedure. > -- > Jenderka Vlastimil > jenderka@post.cz > Have a nice day! > > > Sent via Deja.com http://www.deja.com/ > Before you buy.