Is there a way to force SOME value to be returned from a SELECT query when the result is empty set? For instance:
SELECT nameColumn from theDatabase WHERE rowID = 5; (when no row has ID "5") result --> empty set I would like for it to return some value, such as '' or 0 . . . Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]