> How does SQLite handle sorting with a column that contains values > (including zero) and NULs? Are the NULs converted to zero for the > purposes of sorting?
A null value is considered less than all other values when sorting. http://www.sqlite.org/datatype3.html#comparisons Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users