Hello all,

How can I find the highest integer value in a result set like:

1
10
11
2
3
a
ab
abc

I'm looking for the value 11.

The statement 'select max(field) from table' gives me 'abc' so this won't
do.

Any ideas for a SQL statement that will do the trick?

I'm using PHP / MySQL.

Thanks!

Simon.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to