EQUALS

Syntax

EQUALS(<any>;<any>)

Description

Checks to see if two values are identical by comparing the arguments of one column with the arguments of another column. Both columns must contain the same data type. EQUALS then returns a Boolean value, either true if both arguments are equal or false if the arguments are different. If one of the arguments is null, EQUALS returns false.

Examples

Data field type	Column1	Column2	EQUALS returns

Data field type	Column1	Column2	EQUALS returns
Integer	15	35	false
Integer	23	23	true
Integer	23	null	false
Float	7.6	7.6	true
Float	8.6	15.3	false
Float	15.3	null	false
Date	Aug 2, 2011 3:55:03 PM	Oct 15, 2010 4:34:34 AM	false
Date	Mar 2, 2002 1:24:12 PM	Mar 2, 2002 1:24:12 PM	true
Date	null	Mar 2, 2002 1:24:12 PM	false
Boolean	false	true	false
Boolean	true	true	true
Boolean	true	null	false
String	Germany	George	false
String	George	George	true
String	German	Germany	false
String	null	George	false
List	[ 1, 2, 3, 4 ]	[ 1, 2, 3, 4 ]	true
List	[ 1, 2, 3, 4 ]	[ 5, 6, 7, 8 ]	false
	null	null	true

Instead of using a function, you could also use the equality operator ==.