Equivalency

0     0     Edited Sep 1, 2015

---

Equivalency functions are:
== equals
!= doesn't equal
< less than
> greater than
<= less than or equal to
>= greater than or equal to

May be used as a vector expression or a scalar expression. The context of its usage within syntax will determine which form is used.

Vector Usage:
When used as a vector expression, usage is:
[vector]x ← [vector]a == [vector]b

x_i is set to true if a_i equals b_i.
x_i is set to false if a_i doesn't equal b_i.
x_i is set to null if either a_i or b_i are null.

Examples:
country==1
statecode!="FL"
(country==1) == false
year>=1999

Scalar Usage:
When used as a scalar expression, usage is:
[boolean]x ← [scalar]a == [scalar]b

x is set to true if a equals b.
x is set to false if a doesn't equal b.
x is set to null if either a or b are null.

Examples:
sum(Q1) >= 10
validcount(Q1) == validcount(total)

---