>> Firdt idea: NULL's usually need to be handled separately because
>> nothing equals NULL, not even NULL. You may only check for NULL using
>> the "is null" operator.
>>
>
> Another option for testing null values is to use distinct as in if (value1
> is distinct from value2) then...
> It's only syntactic sugar as they say but it does save a couple of lines...

This is new in Firebird 2.0 and isn't available in earlier versions of
Firebird. Just in case someone tries that with Firebird 1.x. ;-)



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com