Frank Chang wrote: > Could anyone tell me if I should replace COALESCE with ISNULL in the > subselect
A COALESCE with two parameters behaves identical to IFNULL. > in order the improve the speed There will be no difference. (Except that IFNULL saves two characters in the SQL command string. ;-) Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
