Return
-
Title
Using the SUBSTR function in a calculated field in Query Builder produces the wrong syntax -
Description
If I connect using ODBC, does not matter which database platform it is for, and I try to create a calculated field in the Query Builder using the SUBSTR function, the query does not come out correct. It includes a From and For in the syntax, instead of commas.
It looks like...
,SELECT SUBSTR(NUM_TEST."COL1" FROM 1 FOR 3) AS sub_col
FROM "5050".NUM_TEST NUM_TEST
,...instead of...
,SELECT SUBSTR(NUM_TEST."COL1", 1, 3) AS sub_col
FROM "5050".NUM_TEST NUM_TEST
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.