Re: [sqlite] concatenation of row with NULLS suppresses all values

[D. Richard Hipp]

On Mon, 2005-03-28 at 21:38 -0800, Jim Dodgen wrote:
> thanks Derrell ,
> I guess I expect to see just the null values suppressed and the values that 
> exist to show up
> 
> something like this:
> 
> 1--
> 2--
> 3-33-333
> 

NULL concatenated with anything is still NULL.  So the output
should be

    NULL
    NULL
    3-33-333

-- 
D. Richard Hipp <[EMAIL PROTECTED]>