Evaluates expressions while the main command processes a set of records.
|expression||Any valid expression, but usually an assignment using LET and an aggregate function. If expression is complex, it must be enclosed in parentheses.|
change all Employees where LastName = Smith
let Salary = 1.1 * Salary
evaluate (let ExtraCost = $ total(Salary * 0.1))
Determines how much extra money is needed after all employees named Smith are given a 10% pay raise.
let RegTot=0 RegTot=0 RegTot=0
evaluate (let RegTot[RegNum] = RegTot[RegNum] + SalesAmt)
Calculates total sales by region assuming three regions were served by the same sales force.