When creating an automation script, the 'Set Variable' function will not set any variable that does not start with a number.
For example, the variable '1H-358' can be set from a recordset and works as expected. The variable supplied to the rest of the script is '1H-358'. However, if the variable is 'H-358' then the variable is clipped and runs as if the variable were set to '-358'.
Any value of a string variable containing slash (/) or hyphen (-) is treated by our parser as an expression.
WORKAROUND:
Add the numeral '1', by concatenating it to the beginning of the value needed. Then use SUBSTR() to remove it where you need to have the actual value.
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts.
