I have data in a text field with a mixture of records being either all upper case text or being of mixed case text (e.g., MARY SMITH; George Simpson). I need a simple way to convert "upper case" records to mixed case.
Using a query, I can change everything to uppercase or lowercase -- but I'm not sure how to get to "mixed".
The database I'm looking at is actually an SQL database and I'm linking to the the tables using Access.
Any help would be appreciated.