Any case to --> upper case

[kkalvin26]

Hello I have a database that I use to print mail labels and recently my agency requested that I now print the labels with all upper case print.

I have simple text fields ie.. Business Name, and Contact 1.. these have

information that is not formatted to all upper case, I searched around the forums and I am not sure how I can take all 2000 records and convert them to upper casing.. I see a function named upper("text") but I am not even sure if it will do what I need please help..

kkalvin26

[Jack]

Well, here is a down and dirty solution:

Use a font that only has upper case letters.

Then all the info will be printed in upper case.........

HTH

Jack

[Kurt Knippel]

Upper () will do what you are looking for, although I would instead suggest that you simple format the fields on the label as Uppercase.