Automation file where I want to prompt user for an Entity code whose value can be either Alphanumeric or Numeric.
In straight SQL when prompting for the value with a variable either type returns fine.
However, in automation the Alphanumeric works but the codes that are fully numeric fail as "Invalid Number". I've tried a number of functions in the SET VARIABLE activity, many of which work for the Alphanumeric but still fail for the fully numeric values. Variable type = String in the Set Variable set up.
Thanks for any help