I'm trying to extract one record that has largest sequence ID number for an employee, so I've tried below but doesn't work. Help. $mQuery = "EmployeeID = '$user'"; $mCur = odbc_exec( $mCnx, "select ID=max(ID),Date,TimeIn,TimeOut,StationIP from Clocks where $mQuery" ); ------------------------------------------------- This mail sent through ISOT. To find out more about ISOT, visit http://isot.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php