RE: Enforcing Data Format

[Edward Kay]

> > Is it possible to enforce data formatting in fields using
> something like
> > a regular expression?
> > varchar is great but does not stop someone putting in the wrong
> > reference number.
>
> Dates should be in a DATE column, not a varchar.

The OP says 'data' not 'date' :) He is talking about a reference number that
needs to be in a certain format.

I too would argue that this requirement is more application layer than in
the database. Surely anyone editting the tables directly should know what
they're doing and adhere to the correct format.

Edward