Jim,

The RAND() function yields a RANDOM number between 0 and 1. When I want a random number I use the following function :

ln_random = INT((RAND() * range)) + beginning_of_range

This gives me a random number between two integers. This statement is used after seeding the RAND function.