topic SQL Substring in App Development

SQL Substring

stew_scott90 — Fri, 17 Nov 2017 18:48:45 GMT

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 — Fri, 17 Nov 2017 18:52:41 GMT

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 — Fri, 17 Nov 2017 19:00:18 GMT

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

sunny_talwar — Fri, 17 Nov 2017 19:01:12 GMT

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

rwunderlich — Fri, 17 Nov 2017 19:30:28 GMT

What database platform are you connecting to?

-Rob