Re: [exim] sqlite lookups and .nullvalue

On 17/09/15 09:26, Jeremy Harris wrote:
> Why not use an SQL coalesce(field, '') ?

Because I wasn't aware of that solution - thank you I think that seems
to work! (Combined with group_concat, else the results aren't concatenated)

     > select coalesce(recipients, '') from aliases where recipients = 
"blah";
     alias1
     alias2

     > select coalesce(group_concat(recipients), '') from aliases where 
recipients = "blah";
     alias1,alias2

Cheers,

Nick