SQLite Forum

Thanks for reply, trying this:

invoice VARCHAR CONSTRAINT "CHECK(invoice != '';)" NOT NULL,

or

invoice VARCHAR CONSTRAINT "CHECK(invoice <> 0)" NOT NULL,

but have no luck. There are too few examples on the web...