2 Replies Latest reply on Oct 20, 2013 6:56 AM by BorisKamp

    uppercase first letter of all words in field

    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!