My Google-fu appears to be weak. SQLite apparently supports a CASE ... WHEN construction. Where on www.sqlite.org is the meaning defined ? I can see CASE mentioned in diagrams on
http://www.sqlite.org/lang_expr.html http://www.sqlite.org/syntaxdiagrams.html but I don't understand the use of the optional expression immediately after the CASE token. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users