Not

Table of Contents



NOT negates the Like and Between operators: NOT LIKE matches the values that don't fit a pattern, and NOT BETWEEN matches the values outside of a range. For other conditions use != or the boolean functions, such as IsNotEqual(a, b) = 1.

round-pushpin Selects words that do not begin with 'Cat'.
SELECT * FROM WordList:Word WHERE Text NOT LIKE 'Cat%'

round-pushpin Selects words whose Id is not between 2 and 13.
SELECT * FROM WordList:Word WHERE Id NOT BETWEEN 2 AND 13




SQL :: Between
Matches values that fall within a given range.
SQL :: Expressions
Literals, operators, comments and variables in KBSQL.
SQL :: IsLike
Returns true (1) if the text matches the pattern. The pattern uses the same wildcards as [[Like]]: % matches any number of characters and _ matches a single character.
SQL :: IsNotLike
Returns true (1) if the text does not match the pattern. See [[Like]] for the wildcards.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: Like
Allows basic pattern matching in a where clause.
SQL :: Where
The where clause filters the documents read, updated or deleted by a statement.