SQLite Forum

Check Contraints
Login
Chronological Hierarchical 
You would also need to check that length(vin) > 0.

```
CREATE TABLE Vehicle(
  Vin      TEXT NOT NULL PRIMARY KEY,
  Odometer INTEGER NOT NULL,
  CHECK (length(vin) > 0 and Vin GLOB Replace(Hex(ZeroBlob(Length(Vin))), '00', '[A-Z0-9]'))
);
```

That is a very neat idea though.