> > > 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
> needs to be in a certain format.
Woops, I stand corrected :-)
Dang, I really should stop reading data as date. I do that quite often.
> 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.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!