These operators can be used in constructing a where clause

Example	Name	Result
array('$a = $b')	equal to	TRUE if $a is equal to $b
array('$a != $b')	not equal to	TRUE if $a is not equal to $b
array('$a <> $b')	not equal to	TRUE if $a is not equal to $b
array('$a < $b')	less than	TRUE if $a is less than $b
array('$a <= '$b')	less than or equal to	TRUE if $a is less than or equal to $b
array('$a > $b')	greater than	TRUE if $a is greater than $b
array('$a >= $b')	greater than or equal to	TRUE if $a is greater than or equal to $b
array('$a =~ $b')	like	TRUE if $a matches the pattern $b. Also see: LIKE clauses
array('$a !~ $b')	not like	TRUE if $a does _NOT_ match the pattern $b.
array('$a ? $b')	instring (txtSQL >= 2.2.2 RC2)	TRUE if $b is in $a
array('$a !? $b')	not instring (txtSQL >= 2.2.2 RC2)	TRUE if $b is NOT in $a