Select a random row

[Dudek]

Hi there..

ANybody knows how to select a random row from a table?

The table has a key, but the key's number jumps occasionally so i couldnt use like below:

select convert (int, max(key) * rand())

for a random key, as it will sometimes give out a null number

So anybody can help me here?

Thanks
JD