<> operator (Is Not Equal To)

<> (Not Equals -- also != or ≠)

VALUE1

VALUE2

The <> operator compares two values to see if they are different.

Parameters

This operator has two parameters:

value1 – The first numeric or text value.

value2 – The second numeric or text value.

Description

The <> operator compares two values to see if they are different. The result is true if the values are different and false if they are the same. If text values are compared, the result will only be false if the two values are exactly the same, including upper and lower case (use the notmatch operator if you want to ignore case). Here are some examples:

34 <> 34 ☞ false
34 <> 45 ☞ true
"abc" <> "abc" ☞ false
"abc" <> "xyz" ☞ true
"abc" <> "ABC" ☞ true
"123" <> 123 ☞ true

You can also spell out the operator name or use the ≠ symbol or != symbol, like this:

984 isnotequalto 984 ☞ false
"abc" ≠ "xyz" ☞ true
8309 != 2389 ☞ true

Note: The Boolean values true and false are actually integer (numeric) values -1 and 0.

Note: If you are a “C” programmer, Panorama’s = operator is equivalent to C’s != operator. (In fact, Panorama will allow you to use != if you wish, and you can also use ≠ by pressing OPTION-=.)

See Also

< -- compares two values to see if the first value is less than the second value.
<= -- compares two values to see if the first value is less than or equal to the second value.
= -- compares two values to see if they are the same.
> -- compares two values to see if the first value is greater than the second value.
>= -- compares two values to see if the first value is greater than or equal to the second value.
and -- returns true if both operands are true.
beginswith -- returns true if the value on the left starts with the value on the right, false if it doesn't.
between( -- checks to see if a value is between two other values.
boolstr( -- converts a Boolean value to text, either `"true"` or `"false"`.
contains -- returns true if the value on the left contains the value on the right, false if it doesn't.
containsword -- returns true if the text contains a specified word, false if it doesn't.
endswith -- returns true if the value on the left ends with the value on the right, false if it doesn't.
false( -- returns false.
like -- checks to see if the text on the left matches the wildcard pattern specified on the right.
limit( -- checks to see if a value is between a minimum and maximum value. If it is, the value is returned unchanged. If it is below the minimum, the minimum value is returned. If it is above the maximum the maximum value is returned.
match -- checks to see if the text on the left matches the wildcard pattern specified on the right.
matchexact -- checks to see if the text on the left matches the wildcard pattern specified on the right.
not -- reverses a boolean value.
not( -- reverses a Boolean value
notbetween( -- checks to see if a value is *not* between two other values.
notcontains -- returns true if the value on the left does not contain the value on the right, false if it does.
notmatch -- checks to see if the text on the left does not match the wildcard pattern specified on the right.
notmatchexact -- checks to see if the text on the left doesn't match the wildcard pattern specified on the right.
or -- returns true if either operand is true, or false if both are false.
regexmatch -- checks to see if the text on the left matches the regular expression on the right (see Regular Expressions).
regexmatchexact -- checks to see if the text on the left matches the regular expression on the right (see Regular Expressions).
soundex( -- computes a four character code that roughly corresponds to the phonetic pronunciation of the word.
soundslike -- compares two words to see if they "sound like" each other.
switch( -- chooses from a list of values.
true( -- returns true.
xor -- returns true if one of the two parameters is true, false if neither or both are true.

History

Version	Status	Notes
10.0	Updated	Carried over from Panorama 6.0 but no longer results in an error if there is a type mismatch -- instead simply returns true (i.e. not equal).