SQL Guide : solidDB® SQL statements : Common clauses : check_condition
  
check_condition
check_condition
 
check_condition
::= check_item | check_item { AND | OR } check_item
check_item
::= [NOT] { check_test | ( check_condition ) }
check_test
::= comparison_test | between_test |
like_test | null_test | list_test
comparison_test
::= expression { = | <> | < | <= | > | >= }
{ expression | subquery }
between_test
::= column_identifier [NOT] BETWEEN
expression AND expression
like Jest
::= column_identifier [NOT] LIKE value
[ESCAPE value ]
null_test
::= column_identifier IS [NOT] NULL
\ist_test
::= expression [NOT] IN ( { value [, value ]...} )
See also
Common clauses