In access, I use the following statement to select a random row: "SELECT TOP 1 * FROM Questions WHERE Not QuestionID IN (0) ORDER BY RND(QuestionID)". How might I accomplish this same thing in SQLite?
select * from questions ... order by random() limit 1;
Frank
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]