RAND() returns a random number >= 0 and <1 So the following returns a random integer between 0 and <50: ROUND(RAND() * 50) The following returns a random integer between 10 and <60: ROUND((RAND() * 50) + 10 )