>>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
Well as I have said Cetin in my post that I have the Format set to ! for the field in my database. If you browse the records it is uppercase, which is what the help documents stated. But if you '? usrname' to the screen or query the database you will see returned a non-upper case usrname. So that is what is really stored in the Database. That is why I asked the question can the database really stored a field as uppercase no matter how it is sent and not just display it to me in a browse as uppercase.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope