RAND(-1)
SELECT TOP 150 *, (RAND() * 1000000) as rn  ;
	FROM mytable ;
	ORDER BY rn ;
        INTO CURSOR crs150 

>
>i am expected to generate a question paper consisting of 150 questions from a database of 2500 questions. Further, I am supposed to generate the question paper each time someone is required to take a test by RANDOM selection of questions from the above database.
>
>Can someone please enlighten me as to how i can go about RANDOMLY selecting 150 questions each time as i do not have the slightest idea as to how to go about this task ?
>
>With sincere thanks.