Re: ISNULL FUNCTION

--- 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