We basically just want all the names in the field to be proper cased as you said most people are used to seeing Macdonald.

After further thought, we could just run two separate queries if we can determine how many spaces are in a field using the WHERE clause.

Does anyone have any idea how to count specific characters (spaces) in a field?