PATHITEM
The PATHITEM function returns the item that occupies the indicated position in a string resulting from executing the PATH function, being the positions counted from left to right.
hash
The hash function returns the hash value of the object passed as a argument -if any-. Hash values are integers. Numeric values that, when compared, return True have the same associated hash value, even if they are of different type.
PATHCONTAINS
The PATHCONTAINS function returns the logical value True if the specified element exists in the path.
PATH
The PATH function, used in hierarchical data environments (see example below), returns a text string with the identifiers of all parents of the current identifier, starting with the furthest.
input
The input function returns the value of prompt -if it has been included as an argument to the function-, reads a line from the standard input -the keyboard, by default-, converts it to a text string and returns it as result of the function.
COMBINEVALUES
The COMBINEVALUES function joins two or more text strings into a single string by adding a separator between them.
SELECTCOLUMNS
The SELECTCOLUMNS function returns a table made up of columns calculated from an existing table or from an expression that returns a table.
ADDCOLUMNS
The ADDCOLUMNS function adds calculated columns to a table or expression that returns a table.
CUSTOMDATA
The CUSTOMDATA function returns the contents of the CustomData property of the connection string.
enumerate
The enumerate function accepts as an input argument a sequence, an iterator or another object that supports iteration and returns an iterator of type "enumerate" composed of tuples formed by a counter (starting with the value start) and each of the values of the input iterator.
