Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 ]null[ 5, 6, 7, 8 ]false

nullnulltrue
Tip

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