Hello, I have a table with rows of data formated in various cases. Example: "THis is A hAppy Cat. sometimes This cat is Unhappy."
I would like to use a function in a query that can turn it into "This is a happy cat. Somtimes this cat is unhappy."
I do not want to capitalize the first letter of every word, however only the first letter of the first word in each sentence for proper formating.
Thanks for your help on this.