AnsweredAssumed Answered

uppercase first letter of all words in field

Question asked by BorisKamp on Oct 20, 2013
Latest reply on Oct 20, 2013 by BorisKamp

Title

uppercase first letter of all words in field

Post

     Hi!

     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....

      

     Thanks!

Outcomes