SELECT to return 0 instead of NULL?

["Tuc at T-B-O-H.NET" <ml@xxxxxxxxxxx>]

Hi,

	I'm running a query :

SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot';

	But if there aren't any rows in "radacct" for the UserName of
"hotspot", it returns a NULL. Is there a way to change it to return 0
instead? (I can't change the application, but I can change the SQL)

		Thanks, Tuc

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx