In CMS, all project titles (what is also called the "Qualifying Phrase") appear in capital letters in the database. However, they appear in capitals due to a mask on this field whilst really behind the scenes, the project titles may be in lower case or may be in capitals depending on how they were typed in. This is only a problem when it comes to reporting as the report will print out the real case behind the scenes, not the capital mask. Hence if you have a mixture of titles in capitals and lower case, it does not look good.

A quick way to impose consistency is to paste the following pieces of code into the SQL Scratchpad (Utilities - System Manager - Utilities - SQL Scratchpad) and run the code. It will update all the fields behind the scenes and ensure that they are all the same. You have two choices - to change everything to upper case automatically or to change everything to lower case (with the first letter being a capital). You may have to edit from there but at least is quicker than doing it manually.

The capital letter mask is being removed in the 2007 Maintenance release so it will be easier to see what is what.

If you want to change all the project titles into capital letters, paste the following code into the SQL Scratchpad and run:

UPDATE ProjectPlans SET ProjectPlans.ProjectCode = UCase([ProjectCode]), ProjectPlans.QualifyingPhrase = UCase([qualifyingPhrase]);

If you want to change all the project titles into lower case (with the first letter as a capital), past the following code into the SQL Scratchpad and run:

UPDATE ProjectPlans SET ProjectPlans.ProjectCode = UCase([ProjectCode]), ProjectPlans.QualifyingPhrase =
UCase(Left([qualifyingPhrase], 1)) & LCase(Mid([qualifyingPhrase], 2));