CREATE TABLE CRS_2004_001 ( etl_extract_id INTEGER PRIMARY KEY,
courseid, coursekey char, status, schoolid, lowgrade, highgrade, effectdate,
^^^^^^^^^^^^^^
expdate, description, title, longtitle, etl_error DEFAULT 0 );SQLite is trying to compare the values as numbers. You should put types on all your columns. SQLite doesn't require explicit typing, but it doesn't ignore explicit types either. You can read the details on the documentation page of sqlite.org. Regards
