hello there i have a question
if i have a table with several records one of the fields is numeric
how can i display the record with the biggest value
assuming i dont know the values of the records.

thanks


Visit my home page
www.cancuncoral.com

Assuming that the numeric field is called priority and the table is called orders that you can do it like this:

<pre id=code><font face=courier size=2 id=code>
SELECT MAX(priority) FROM orders
</font id=code></pre id=code>

<hr><b>DMXZone support manager</b><br><a href="www.kousman.nl">Kousman web resellers</a>