This is version 1 2 3 4 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

LIKE - Is Like The Is Like (Like) operator checks to see if the value in Operand 1 is the same as the value in Operand 2. (Operand 2 must be a masked string using acceptable Oracle search criteria). Statement: If the employee is in any sales department, give a bonus of $500.00 (stored in PC 5000).

Line	CMD	OT	Operand 1	OPER	OT	Operand2	OT	Operand3	If Goto	Else GoTo

00010 IF DB DDP.DEPARTMENT_CODE LIKE A SALES% 00100 99999 00100 LET PC 5000 EQ N 500 99999 99999 EXIT 99999

In the example shown above, if the employee’s department began with the string ‘Sales’, the UserCalc would go to line 100 to give the bonus. Acceptable department codes would be ‘Sales-001’ or ’SalesHeadOffice’ but not ‘GroupSales’.