On 17 Sep 2012, at 4:30pm, "Black, Michael (IS)" <michael.bla...@ngc.com> wrote:
> sqlite> select count(*) from t where length(a) = 0; > 1 There it is again. What does length(NULL) mean ? Should it be NULL because anything derived from "Don't know" is "Don't know" ? Or should it be a non-negative integer representing how long the NULL value is ? I may have missed it, but I don't think the answer is in SQL92. The only solution is not to depend on any particular behaviour. Math is hard. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users