>, Ucase, or however you would do it

[Brenkenathan]

I have a table and I would like to have all fields in the table be uppercase, but using an input mask only affects cells that are created after the input mask is put in, how would I go back and make all of the cells Upper case? Thanks

 

[parry]

Hi, Ucase is the correct function and use this in the "Update To" line of an update query.

eg
Field: field1
Table: table1
Update To:ucase(field1)