* Joseph Witkin <jwitkincts.com>:Tha Random function returns a random value between 0 and 1. Before you>
> I can't figure out how to use the "random" function to give me a random
> integer between 1 and 500. Its driving me nuts!
start thinking that its 0 or 1 think about the number of possibilities
in terms of decimal values between 0 and 1.
Now in terms of finding a value to go to a record in your db I suppose
you could use the middle function and pull a couple of numbers from the
random result, however, I bet another one of the fine people in this
group have a fabulous mathematical answer for you.