Randomiztion Function SQL

<i><b>Originally posted by : Paul (paulf2@hotmail.com)</b></i><br />Does anybody happen to know what that Randomization for SQL 7.0 is?<br />MySQL is 'RAND', but this won't work on SQL 7.0.<br />Anybody come across this problem?<br />

<i><b>Originally posted by : notimportant (jhunt@alagreen.com)</b></i><br />Try using a user defined function especially in a WHERE CLAUSE.<br /><br />SELECT * FROM <table> WHERE myudf() > .5<br /><br /> PROCEDURE myudf()<br /> RETURN RAND() <br /><br /><br />------------<br />Paul at 4/19/2001 4:20:43 AM<br /><br />Does anybody happen to know what that Randomization for SQL 7.0 is?<br />MySQL is 'RAND', but this won't work on SQL 7.0.<br />Anybody come across this problem?<br />