That's odd. I thought I've tried it and it doesn't work,
but now it works.

thnx
Jörg

----- Original Message -----
From: "Art Metz" <ametz@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, February 01, 2001 5:34 PM
Subject: RE: [ib-support] negation


> -----Original Message-----
> From: Jörg Schiemann [mailto:schimmi@...]
> Sent: Thursday, February 01, 2001 8:08 AM
> To: IB-Support
> Subject: [ib-support] negation
>
>
> Hi everybody,
>
> can anyone tell me how to negate IS NULL in a SP?
> Or is the only way IF IS NULL THEN ELSE ?

IS NOT NULL works for me.

Art


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com