On 17/09/15 08:14, Nick wrote:
> I've a sqlite lookup which executes a query like this:
>
> select group_concat(recipients) from aliases where stem = "blah";
>
> The problem is, when there are no matches, the result in exim is the string "NULL".
>
> I see there is a config option in the sqlite command line client:
>
> .nullvalue STRING Print STRING in place of NULL values
>
> Is it possible to modify this setting in exim so that my lookups result in ""?
Why not use an SQL coalesce(field, '') ?
--
Cheers,
Jeremy
