Re: Null in string concatenation

Rafal Furdzik wrote: > > If a.first is null,this select will return nulll > > Select a.last || ', ' || a.first > From a > > How to return a.last only in case if a.first is null. Please help. select a.last || ',' from a where a.first is null union select a.last || ',' || a.last from a where a.first is not null; Art S. Kagel