Subject | Problem with Varchars and null |
---|---|
Author | Galante Hernan (SFA) |
Post date | 2002-01-23T12:29:33Z |
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
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