Using sqlite3 3.5.4 I have created a SQLite database and loaded it from a csv file using the sqlite .import statement with a comma separator.
When .import parses an empty field in the csv file, that is , a comma immediately followed by another comma, is the cell, in the database, that corresponds to the empty field a NULL cell? The reason I ask is that when I query the column with SELECT COUNT(*) FROM table WHERE temp ISNULL; 0 is returned but there are 5 empty cells in that column in the csv file. Also when I query SELECT temp FROM table WHERE temp > 0; the empty cells are returned as well as the cells containing temperatures over 0. Robert Wishlaw ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
