>My goal is to have the first character of a set be an upper case character and the rest of the characters be lower case for each field in my table. My fields have multiple sets of characters in them. Is there an easy way to do this?

Try replace myfield1 with proper(myfield1), myfield2 with proper(myfield2) in mytable.