OK, thanks. A little more optimisation :) > On 1 Nov 2014, at 17:39, Igor Tandetnik <[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
