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