SQL Reference

Relational operators

Relational operators specify how SQL compares expressions in basic and quantified predicates.

This is the syntax for relational operators:

= <> != ^= < <= > >= |

The following table lists the relational operators and the resulting predicates for each operator.

Relational operator | Predicate for this relational operator |

= | True if the two expressions are equal. |

<> != ^= | True if the two expressions are not equal. The operators != and ^= are equivalent to <>. |

< | True if the first expression is less than the second expression. |

<= | True if the first expression is less than or equal to the second expression. |

> | True if the first expression is greater than the second expression. |

>= | True if the first expression is greater than or equal to the second expression. |

In this section:

© 2017 Progress Software Corporation and/or one of its subsidiaries or affiliates. All rights reserved.

Progress® OpenEdge® Release 11.7