Re: [SQL] ISNULL FUNCTION

[Ludwig Lim]

--- Héctor Iturre <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org