> 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

Reply via email to