Simon Slavin wrote: > What does length(NULL) mean ? When there is no string, there is no string length.
> I don't think the answer is in SQL92. | 6.6 <numeric value function> | [...] | General Rules | [...] | 4) If a <char length expression> is specified, then | Case: | a) Let S be the <string value expression>. If the value of S is | not the null value, then [...] | b) Otherwise, the result is the null value. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
