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 |