4 Replies Latest reply: Nov 17, 2017 2:30 PM by Rob Wunderlich RSS

    SQL Substring

    Stewart Scott

      I use the following Substring in an SQL statement in a few different apps and it works as expected:

      Substring(Upper(Coeuser),10,100)as `MgrCoeuser`

       

      I've created a new app and am trying to reuse the string above and I'm receiving the following error(see image):error image.PNG

      If I remove the Substring statement the data load completes without any issues.