6 Replies Latest reply: Sep 26, 2013 12:15 PM by Jennie Elliott RSS

    Trim Leading Space

    Jennie Elliott


      Kind of stuck on this one, I need to trim the leading spaces from only PEO_FirstName and it does not appear to be working. What would be the correct syntax for this line?

       

       

      Upper(LTrim(PEO_FirstName)) & ' ' & Upper(PEO_LastName) as KEY|CustomerName,

      Thanks!