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.
Connect using a native client of the database platform you are using, instead of ODBC. This will not be possible for all database platforms.
Manually edit the SUBSTR syntax in the calculated field before clicking OK to submit it to the query builder.
Waiting for fix to be released in a future version of Toad for Data Analysts.