Since NULL is a state, a state of unknown value, not a value, the behaviour
you see is correct. If you take an unknown value (NULL) and concatenate it
with anything, the result can only be unknown (NULL state), right ?? Of
course.

Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>



-----Original Message-----
From: Galante Hernan (SFA) [mailto:galanteh@...]
Sent: Wednesday, January 23, 2002 5:30 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] Problem with Varchars and null


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


Yahoo! Groups Sponsor
[]



_____


<http://us.adserver.yahoo.com/l?M=153641.1824646.3335993.1261774/D=egroupmai
l/S=1705007709:HM/A=919242/rand=102922379>

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



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .