Page last modified 05:52, 30 Aug 2008 by Admin
    Table of contents
    No headers

    Version as of 05:11, 10 Apr 2020

    to this version.

    Return to Version archive.

    View current version

    Comparison operators

    Summary Comparisons used to express relationships (e.g. greater than, equal to) between values.
    Maintainer Information Technology
    Source Information Technology
    Affects Various forms and reports that evaluate information based on conditional relationships
    Affected By
    Values SQL is a printf-style string with placeholders (%s) for the left- and right-hand sides of the comparison, or multiple values in the case of more complex expressions.

    The order of the values supplied for the SQL string is the same for all expressions; the left-hand side is always the database value being tested, the right-hand side is what the database value is being compared with.

    For expressions that evaluate a range (e.g. BETWEEN) a lower and upper bound are expected.

    Sets of values can also be used, and are generally constructed from a comma-separated list of values.


    Powered by MindTouch Core