It's not a bug, the result of doing just about anything with a null
value is null.

>From: "Galante Hernan (SFA)" <galanteh@...>
>Reply-To: ib-support@yahoogroups.com
>To: ib-support@yahoogroups.com
>Subject: [ib-support] Problem with Varchars and null
>Date: Wed, 23 Jan 2002 09:29:33 -0300
>
>Hi everybody,
>
> I'm in a problem. I have Interbase 6/NT and I'm trying to do
>this:
>
> Select Ab.Surname || ', ' || Ab.Name as Name
> .....
> from Abogado Ab,
> ......
> where ..............
>
> The problem is Ab.Name in some cases is null .... and for my
>surprise all the operation of concatenating is null. Why? In other
>databases
>the result is Ab.Surname || ', '. This is a bug? Can I resolve this? How?
>
>Thanks in advance,
>
>
>_______________________________________________________
>Hern�n Galante
>"The best way to predict the future is to invent it " by Alan Kay

_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com