Do you mean perhaps to define the table as follows: ``` CREATE TABLE t1 ( a INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 1, b INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 2, c INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 3 ); ``` so that if you try to insert a NULL value you get a default instead? ``` sqlite> CREATE TABLE t1 ...> ( ...> a INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 1, ...> b INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 2, ...> c INTEGER NOT NULL ON CONFLICT REPLACE DEFAULT 3 ...> ); sqlite> insert into t1 values (58,null,null); sqlite> insert into t1 values (null,36,null); sqlite> insert into t1 values (null,38,1748); sqlite> select * from t1; ┌────┬────┬──────┐ │ a │ b │ c │ ├────┼────┼──────┤ │ 58 │ 2 │ 3 │ │ 1 │ 36 │ 3 │ │ 1 │ 38 │ 1748 │ └────┴────┴──────┘ sqlite> ```