Re: ISNULL FUNCTION

--- Hctor Iturre <hhiturre(at)yahoo(dot)com(dot)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 end
from calfiscal
where impuesto = 1

regards,

ludwig

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