random select of data

[wayko]

i want to setup a query that will select a random id from the database and display the information from column according to that id

so far i have

select katakana
from tango
where id = (rand(id)*64)

but the sql says Undefined function RAND in expression

any ideas?

 

[Robby]

You cant use Where ID = ...Because the sequence of numbers may be broken.

Are you using a DataReader or..?

 

[wayko]

No i am not using a datareader

 

[Robby]

Well? What are you using then?

 

[wayko]

nothing

hmmm... let me see how the datareader works
i have yet to use it