comparison_predicate

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

4D SQL Reference
- Syntax rules
- - Syntax rules
  - 4d_function_call
  - 4d_language_reference
  - all_or_any_predicate
  - arithmetic_expression
  - between_predicate
  - case_expression
  - column_definition
  - column_reference
  - command_parameter
  - comparison_predicate
  - exists_predicate
  - foreign_key_definition
  - function_call
  - in_predicate
  - is_null_predicate
  - like_predicate
  - literal
  - predicate
  - primary_key_definition
  - search_condition
  - select_item
  - sort_list
  - sql_data_type_name
  - sql_name
  - sql_string
  - subquery
  - table_constraint
  - table_reference

Home

4D v19

4D SQL Reference

Syntax rules

comparison_predicate



	Command comparison_predic arithmetic_expression {< \|<= \|= \| >= \| > \| <> } arithmetic_expression \| arithmetic_expression {< \|<= \|= \| >= \| > \| <> } (subquery) \| (subquery) {< \|<= \|= \| >= \| > \| <> } arithmetic_expression

Description

A comparison_predicate uses operators like <, <=, =, >=, > or <> to compare two arithmetic_expression type arguments or to compare an arithmetic_expression with a subquery as part of a search_condition applied to the data.