Converting Fields from Lower to UPPER CASE

[srossbach]

I am in the process of cleaning up very large database - some of the text has been entered in lower case and some in upper case - I would like to do a global change to UPPER CASE - how can I do this?
[sig][/sig]

 

[Amiel]

Using 'SQL view' in design mode, drop this in as the query, changing the name of the table and changing or adding field names as necessary...

"Update [table1] Set [Field1]= [red]UCase[/red]([Field1])"
... or even
"Update [table1] Set [Field1]= UCase([Field1]), [Field2]= UCase([Field2])"

Enough ? [sig]<p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br> [/sig]

 

[Guest_imported]

Try putting &quot; > &quot; in the format of the fields that you want to be upper case. Also back in your tables for any new info do the same thing

 

[Vandys]

Putting &quot;>&quot; sign in the format of the fields just changes the display from lower case to uppercase but the data in the tables is still stored the way it is entered i.e. lower case or uppercase or both mixed. So if you wish to **Store** the data in the field in the upper case then you will have to do what Ameil has suggested to first clean your database and then make change in the forms from where the data is inserted into the tables.

Vandys
[sig][/sig]