uppercase first letter of all words in field
Im trying to figure out how to auto uppercase all the first letter from the words in a text field. I have found this:
Upper(Left(Street; 1)) & Right(Street; Length(Street) - 1)
but that only works for the first word...
I do not have a vast amount of words in that field, might be 2 in one record and 4 in another....