Dear Friends Running the follow query
select max( sr_recno) from test_table down work for re the error id returned by mysql_errno is 3731792 server is 4.1.1a-alpha Table structure is SR_DELETEC char(1) SR_RECNO bigint(15) PRI auto_increment VALUE double(18,6) OBS text ENABLE tinyint(4) DATE_LIM date days double(6) percent double(8,2) descr varchar(50) cardid char(1) code_id varchar(8) Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]