Syntax
Description
Checks to see if the arguments in Column1 are less than or equal to the arguments in Column2. Both columns must contain the same data type. LE then returns a Boolean value, either true if the arguments in Column1 are less than or equal to the arguments in Column2 or false if the arguments in Column1 are not less 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.
...
Data field type | Column1 | Column2 | LE returns |
|---|---|---|---|
Integer | 15 | 35 | true |
Integer | 23 | 23 | true |
| Integer | null | 15 | true |
Float | 7.6 | 7.6 | true |
Float | 10.7 | 8.6 | false |
| Float | 10.7 | 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 | Mar 2, 2002 1:24:12 PM | Apr 2, 2010 11:42:21 PM | true |
| Date | null | Aug 2, 2011 3:55:03 PM | true |
Boolean | false | true | true |
Boolean | true | false | false |
Boolean | false | false | true |
| Boolean | false | null | false |
String | Germany | George | false |
String | George | George | true |
String | German | Germany | true |
| String | null | George | true |
| null | null | true |
...