>I was wondering if the database can be defined so that when a field is set up it automatically ensures that the field data is uppercased when stored. I would like the database to ensure some things happen when new data is entered into the tables. One thing is just to ensure that all UserNames are entered as uppercase. So I think that the Database can have some responsibility for ensuring this to happen, instead of a business rule or the presentation tier. I know that the fields have a format area where I can put a !, but this only displays the information as uppercase, it does not ensure that the data is stored in uppercase.
>
>Any suggestions please..
Brett,
AFAIK for new data ! format also effects the storage too.
Cetin