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

Integer

15

35

false

Integer

23

23

true

Integer23nullfalse

Float

7.6

7.6

true

Float

8.6

15.3

false

Float15.3nullfalse

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

DatenullMar 2, 2002 1:24:12 PMfalse

Boolean

false

true

false

Boolean

true

true

true

Booleantruenullfalse

String

Germany

George

false

String

George

George

true

String

German

Germany

false

StringnullGeorgefalse
List[ 1, 2, 3, 4 ][ 1, 2, 3, 4 ]true
List[ 1, 2, 3, 4 ][ 5, 6, 7, 8 ]false

nullnulltrue

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