Table/Data format inconsistencies.

[Ceichhorn]

Hi all! Not sure if there is a good solution to this, so I thought I'd ask.



I have a table (tblStaff) which has inconsistent data formatting: specifically, sometimes the person's name has no caps (robert), the first initial capitalized (Robert), or is in all caps (ROBERT). I would like to adjust this so that all names in the table are in all caps for every record. Is there a method to do this other than brute force? Thanks for the help!

[jwhite]

Your could try the method here (http://www.databasedev.co.uk/proper_case_update.html) on a BACKUP of your database first. NO method is going to catch everything for you, but this will probably be the closest.

[Ceichhorn]

Jwhite,

Thanks very much! I will try that.