> > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]