@Compare

@COMPARE returns "true" or "false" when comparing a member to a member, a dimension to a dimension, a password to password, or a string to a restricted list. (For a restricted list, @COMPARE compares using the rule builder value, not the substituted value.)

DTP Type:

@COMPARE can be assigned to a DTP of type of boolean.

Syntax:

@COMPARE(String,compareString,IgnoreCase)

Parameters:

Parameter	Description
String	Design-time prompt or text
compareString	Design-time prompt or text
IgnoreCase	Optional. If "true," the case of parameters 1 and 2 is ignored. If "false," the case must match for parameters 1 and 2. If IgnoreCase is left empty, it defaults to "true."

Example:

[DTP1]=@COMPARE([MBR1],[MBR2],true)

Where:

• [DPT1] is a non-promptable DTP of type boolean

• [MBR1]=Jan

• [MBR2]=Jan

In this example, [DTP1] returns "true."