"Malik Kuldeep-LKM041" <[EMAIL PROTECTED]> wrote on 11/03/2005 10:48:21 AM:
> Hi, > I have a requirement to always store the UPPER CASE text for the VAR and > VARCHAR type columns in a table. Is there a way I can specify it during > the CREATE TABLE statement? > > Kuldeep Malik > No. That is something your data providing applications will need to do for you. However, with v5.0, you should be able to write a trigger that will upper-case all data inbound to particular tables but you neglected say which version you are running so I offer that only as an option. Triggers are not defined as part of the CREATE TABLE statement. http://dev.mysql.com/doc/refman/5.0/en/triggers.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine