I have a name database that has gotten a bit sloppy over time. Some name enteries are all upper case, some are all lower case and others are correct. My table is called master_name. I am looking for a command to make the first character upper case and the rest lower.
How can I do this?