Re: [sqlite] Stuck and drowning trying to work out some SQL.

[Luuk]

On 1-11-2014 18:39, Igor Tandetnik 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.

Thanks for this confirmation ;)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users