Re: Nulls in Informix
Try with:
create procedure notnull(nold decimal(13,2),nnew decimal(13,2))
returning decimal(13,2); if nold is null then
let nold=3Dnnew;
end if;
return nold;
end procedure
Create this procedure in your database, and now use!
Example:
select notnull(a,"0")
from tabla
Excuse the bad English...=20
GM
=20
At 09:21 AM 12/4/97 -0600, you wrote:
}Hi,
}There is a isnull function in sybase which replaces a NULL output to
}whatever we like -
}eg. select isnull(name,'no name')
}from tab_name
}would result in
}name
}---------------------
}george
}sally
}no name
}panna
}dinyar
}no name
}(6 rows affected)
}
}Similarly there is a function called nvl in Oracle.
}
}Is there a similar function in Informix?
}Thanks in advance
}-Dinyar
}
}-------------------=3D=3D=3D=3D Posted via Deja News=
=3D=3D=3D=3D-----------------------
} http://www.dejanews.com/ Search, Read, Post to Usenet
}
}
Informix Costa Rica
Soporte T=E9cnico
Sistemas Integrales de Computaci=F3n