Rules for comparing two values

If types of values being compared are not identical, the relationship between the values is defined based on the type priority:

  • NULL (lowest)
  • Boolean
  • Number
  • Date
  • String
  • reference types

The relationship between different reference types is defined based on table reference numbers corresponding to one type or another.

If the data types are identical, their values are compared according to the following rules:

  • For Boolean type, TRUE is greater than FALSE.
  • For Number type, common number of comparison rules are applied.
  • For Date type, earlier dates are less than later dates.
  • For String type, the comparison is based on the regional database settings.
  • Reference types are compared according to their values (for example, record numbers).
Next page: Operations with NULL value

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.