Selecting random field !

<i><b>Originally posted by : Para (o0_Para_0o@hotmail.com)</b></i><br /><br />hi , here's my proberlem ...<br /><br />i need to connect to a DB , and select a RND entry based on fields requirements ..???<br />say this is my SQL string :---><br />SQL="SELECT Field1 from tblname where counter >=1"<br /><br />What i want to do is too select a Random entry in Field1 from tablename where counter >= 1 ....<br /><br />Is there anyway you select a Random entry using the SQL statement ? or would i need some sort of array ?<br />