C Curt_C [MVP] May 19, 2004 #2 Count the rows, generate a random # from 1 to X Get row x. Mind you you really should get the unique ID's, put them into an array/list, generate the random from there.
Count the rows, generate a random # from 1 to X Get row x. Mind you you really should get the unique ID's, put them into an array/list, generate the random from there.
R Raterus May 19, 2004 #3 if you are using sql server select top 1 * from mytable order by newid() I think you should be able to find plenty of articles on how to display data from a database.
if you are using sql server select top 1 * from mytable order by newid() I think you should be able to find plenty of articles on how to display data from a database.
