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