Scoutmasters Are Stoopid

In modifying my original summercamp database program to work with wintercamp, I realized that some people don’t understand what the SHIFT key on the computer is for. In other words, most of the data that I receive from the online registration interface is completely lowercase. This, however, presents a problem; information that I produce for Ho Non Wah is official. We can’t have lowercase names being seen by anyone who matters (this implies that I don’t matter). I needed a way to quickly change the case of the LastName and FirstName fields to proper case, so this is what I came up with.

UPDATE CurrentWeek SET CurrentWeek.LastName = StrConv([LastName],3), CurrentWeek.FirstName = StrConv([FirstName],3);

If I call that piece of SQL from an update query, I can easily update all of the records in the table without touching a single piece of data. This doesn’t take into account names like Mc, Mac, (and Paddywack), but a quick sort in ascending order of the LastName field will show any of the M’s that need specialized attention. I could modify this code at a later date, but this quick and dirty solution works for now.