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 two values can be either text or numeric, but they must both be the same type. 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


History

VersionStatusNotes
10.0UpdatedCarried 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).