GE

Syntax

GE(<any>;<any>)

Description

Checks to see if the arguments in Column1 are greater than or equal to the arguments in Column2. Both columns must contain the same data type. GE then returns a Boolean value, either true if the arguments in Column1 are greater than or equal to the arguments in Column2 or false if the arguments in Column1 are not greater than or equal to the arguments in Column2. If one of the arguments is null, that value is lesser than other values, unless all arguments are null.

When comparing strings, first the characters are paired, then the Unicode value of these pairs are compared. If the character pairs are the same, the length of the string is compared. See COMPARE for more information, as these functions operate similarly.

Examples

Data field type	Column1	Column2	GE returns

Data field type	Column1	Column2	GE returns
Integer	15	35	false
Integer	23	23	true
Integer	15	null	true
Float	7.6	7.6	true
Float	10.7	8.6	true
Float	null	7.6	false
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	true
Date	Mar 2, 2002 1:24:12 PM	Apr 2, 2010 11:42:21 PM	false
Date	Mar 2, 2002 1:24:12 PM	null	true
Boolean	false	true	false
Boolean	true	false	true
Boolean	false	false	true
Boolean	null	true	false
String	Germany	George	true
String	George	George	true
String	German	Germany	false
String	George	null	true
	null	null	true

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