Thread: ISNULL FUNCTION

HI,  HERE IS AN ALTERNATIVE TO USE THE SQL SERVER
ISNULL() FUNCTION


select case when FIELD_NAME isnull then 'EXPRESION' 
else FIELD_NAME end
from calfiscal
where impuesto = 1

Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil:
http://ar.mobile.yahoo.com/sms.html

--- H�ctor Iturre <hhiturre@yahoo.com.ar> wrote:
> HI,
>    HERE IS AN ALTERNATIVE TO USE THE SQL SERVER
> ISNULL() FUNCTION
> 
> 
> select case when FIELD_NAME isnull then 'EXPRESION' 
> else FIELD_NAME end
> from calfiscal
> where impuesto = 1

try using
 SELECT coalesce(field_name,'EXPRESSION') FROM calfiscal WHERE impuestor = 1

OR 
SELECT case when FIELD_NAME IS NULL then 'EXPRESION' else FIELD_NAME endfrom calfiscalwhere impuesto = 1


regards,

ludwig


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com