I defined a computed varchar field (Name) in EDBManager2 as the concatenation of 2 varchar fields FName and LName (C=A+' '+B).
All three of them are nullable, and yet, if A or B is null, Name is not calculated.
Why???
Or how can this be circumvented?

Van de moortel,

> I defined a computed varchar field (Name) in EDBManager2 as the concatenation of 2 varchar fields FName and LName (C=A+' '+B).
> All three of them are nullable, and yet, if A or B is null, Name is not calculated.
> Why???
> Or how can this be circumvented?

This behaviour is like expected. To avoid it, use the Colalesce-function:

Select Coalesce(FName,'') + Coalesce(LName, '') from mytable.

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=20&topic=452

Uli

Thanks