Capitalize all records in a database

[tinyevil777]

Hey there,

I have a database, which is full of data containing lower and uppercase characters.

Is there an SQL script i can run to capitalize all letters?


The table i am trying to capitalize is called "RQ", and i'm trying to capitalize all data in the table.


Thank you in advance everybody!

Tom

 

[DCrake]

Have a look at either UCase() or StrConv() both will do the job.

 

[vbaInet]

Or put > in the Format property of the field or control.