SQL Substring

[stew_scott90]

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):

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

[sunny_talwar]

Do you do the above within the LOAD statement or SELECT statement? I guess other dashboards might do it in LOAD and this one is doing in SQL SELECT.

[stew_scott90]

This is located in the SELECT statement. When I try putting it in the LOAD it highlights the statement as an error.

[sunny_talwar]

Can you share the old and new script (just the load for a single table is enough)

[rwunderlich]

What database platform are you connecting to?

-Rob