Unequal operator. Attention should be paid to case-sensitivity for comparison of character strings.
<Character string1> <> <Character string2> | |||
---|---|---|---|
Expressions | String | String1 | Compare operator |
String | String2 | Compare operator | |
Return value | String |
Formula | Result |
---|---|
= 'ab' <> 'ab' | false |
= 'ab' <> 'AB' | true |
= 'ab' <> null | null |
The compare operators <,>,<=,>= are defined for character strings, but can be used meaningfully only in exceptional cases, because they compare the sums of the Unicode values of the character strings.