SQLite Forum

Is there a non-trigger way to format data on INSERT/UPDATE?

When inserting / updating some column, I want to convert it to lowercase and change dashes to colons.  So that,

`AB-cD-12` becomes `ab:cd:12`

Without using triggers, is it possible to do this at the table definition level, similar to how a `CHECK` constraint is used?