Clark Christensen <[EMAIL PROTECTED]> wrote: > Long setup for a simple question: Is null the expected result when > one column of a concatenation operation is null?
Yes. Pretty much any operation where at least one operand is NULL produces a NULL. See also http://sqlite.org/nulls.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users