ti3r wrote:Show your query, including NULLS FIRST.
I am not pulling the entire set of records, only 200 that meet the query criteria. When I added the ORDER BY Last_Mailed_Date NULLS FIRST it still did not select the records with null values.
select *has nothing that limits the results to 200 rows.
Last_Mailed_Date IS NULL OR (SYSDATE - Last_Mailed_Date) > 60)