HELP!! Select a record at random

Hi all,

HELP!! - I'd like to select a record by not using a field name to filter. For example, here's what I'd usually do:

SELECT * FROM tblTest WHERE tblTest.ID = " & lngID & "

BUT I'd prefer to do it a bit like this:

SELECT TOP " & intRandom & " * FROM tblTest

As you can see here, this will sonly select 2 records, I want to select one only. Basically what I'm trying to is select a random record in the table. But I don't have a clue how to it, please help

NOTE: I'm using ASP/Vb-Script to code me pages

Thanks for reading