Invantive Script variables are globally named variables with a text value. The names are case-insensitive. # Variable Use The value of an Invantive Script variable can be used in SQL statements or variable value assignment by using the syntax ``` ${NAME} ``` which expands run-time to the string value of the variable. Expansion is recursive: it repeats itself till there are no Invantive Script variables left to expand. An error is raised when an undefined variable name is used. # Define Variable A variable is defined and assigned a value in one combined statement using the syntax: ``` local define NAME "VALUE" ``` The value may refer to other variables using the `${NAME}` notation, such as: ``` local define OUT_PATH "c:\temp" local define OUT_FILE_NAME_PATH "${OUT_PATH}\my-file.txt" ``` [Encrypted values](Encrypt%20Value) can also be used as source for a variable value using the syntax: ``` local define encrypted NAME "ENCRYPTED VALUE" ``` # Undefine Variable The definition of a variable and it's value can be removed using: ``` local undefine NAME ``` # Pre-defined Variables A number of pre-defined variables can be found in [[Pre-defined Variables]].