How about select max(floor(field)) from table ?
TK
Good idea, but...
Using floor produces the following error:
Warning: SQL error: [MERANT][ODBC PROGRESS driver][PROGRESS]Invalid number
string (7498), SQL state S1000 in SQLExecDirect in c:\program
Hi Simon,
One way to solve the problem is this query:
select max(field+0) from table;
Since numeric 0 is added to field, mysql silently converts field column
into numeric first and makes the calculation accordingly.
Beware that pure character strings give zero when converted to numeric type