>order by (f.nexttime is null or f.nexttime=''), coalesce(f.nexttime, ''),f.lastdate
This worked fine re making sure that non-null nexttimes come BEFORE null nexttimes. How would I extend this so that AFTER non-null nexttimes I get NON-NULL lasttimes and then... null nexttimes and lastimes in any order Also can I ask why you are ordering by nextime is null/'' at the beginning... I don't really understand this Regards Dean _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users