Page tree
Skip to end of metadata
Go to start of metadata

Syntax

NOT_EQUALS(<any>;<any>)

Description

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

Examples

Data field type

Column1

Column2

NOT_EQUALS returns

Integer

15

35

true

Integer

23

23

false

Integer23nulltrue

Float

7.6

7.6

false

Float

8.6

15.3

true

Float15.3nulltrue

Date

Aug 2, 2011 3:55:03 PM

Oct 15, 2010 4:34:34 AM

true

Date

Mar 2, 2002 1:24:12 PM

Mar 2, 2002 1:24:12 PM

false

DatenullOct 15, 2010 4:34:34 AMtrue

Boolean

false

true

true

Boolean

true

true

false

Booleannulltruetrue

String

Germany

George

true

String

George

George

false

StringGermannulltrue

nullnullfalse

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

  • No labels