I need a script that will update records and set the first word to UPPERCASE and all remaining words in the string to lowercase.
Example the cltsort field will have either an individuals name or company name.
Reliable Concrete would become RELIABLE concrete
Smith, John would become SMITH, john
Ruby Lake Cafe would become RUBY lake cafe
Any help is greatly appreciated.