OK, thanks. A little more optimisation :) > On 1 Nov 2014, at 17:39, Igor Tandetnik <i...@tandetnik.org> wrote: > > On 11/1/2014 11:52 AM, Luuk wrote: >> Is the 'else null' part needed??, or can it be deleted > > Yes, it can be removed. CASE expression returns null when no case matches. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
