> > Fortunately there is function COALESCE() that will return the first argument > > that is not NULL. In case of NULL values you can use a default value for an > > expression: COALESCE( `col`*2, 14) will produce 14 if `col` is NULL. > > FWIW, IFNULL() does the same thing, with a clearer (to me) name, e.g., > IFNULL(sum(qty), 0).
Do note, that COALESCE is the standard name for this :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]