Re: ISNULL function

[William Chiquito]

Hi Joe,

Depending on the programming language you are using you can do something like:

   if valor = 0 OR IsNULL(valor)

Also from your stored procedure can do something like:

DELIMITER $$

DROP PROCEDURE IF EXISTS `sptest`$$

CREATE PROCEDURE `sptest`()
BEGIN
	DECLARE presult DECIMAL(10, 3) DEFAULT NULL;
	SELECT densidad_r50 INTO presult FROM roos_chamber WHERE depth_cm = 2.1;
	SELECT IFNULL(presult, 0) AS valor;
END$$

DELIMITER ;

Edited 2 time(s). Last edit at 03/24/2008 06:41PM by William Chiquito.