SELECT MAX(ID) from payroll_tbl WHERE unemp_ins_pct > 0 INTO CURSOR tem>Thanks Sergey. I tried your query, but it still seems to bring up the running query box on screen and seems to take same amount (status bar indicates 1 record in 5.41 seconds) of time as the query I designed. I have my indexes in table, and I thought it might be the ORDER BY clause that may be causing slow query, but apparently not.