5 Replies Latest reply on Dec 19, 2018 8:29 PM by Tony Machin

    substituting lower case to capital letters

    Young Song

      Hey all,

       

           Is there a way to substitute lower case to capital letters?  For example, from "chicken" to "Chicken"

       

           I was thinking something in the lines of using LEFT() and Replace() to do this.  Something like:

       

           IF LEFT("chicken",1) IS A LOWERCASE THEN REPLACE(LEFT("chicken",1), UPPER(LEFT("chicken",1)))

       

            So to be more specific, I am looking for a way to check if a character is upper or lower case.

       

      Thank you

       

          Young