Visionary User's Guide

Visionary User's Guide
Appendix C: Functions and Support Syntax

Home Contents Index Master Index New Book

Operators

Visionary supports the operators listed in the table below. String comparisons indicate the case-sensitive lexicographic relation of two strings without regard to locale (for example, the comparison is based on the ASCII codes of the characters).


Operator	Expression	Result
Equality	Numeric1 = Numeric2	Boolean
Less than	Numeric1 < Numeric2	Boolean
Greater than	Numeric1 > Numeric2	Boolean
Less than or equal to	Numeric1 <= Numeric2	Boolean
Greater than or equal to	Numeric1 >= Numeric2	Boolean
Not equal to	Numeric1 <> Numeric2	Boolean
Equality	String1 = String2	Boolean
Less than	String1 < String2	Boolean
Greater than	String1 > String2	Boolean
Less than or equal to	String1 <= String2	Boolean
Greater than or equal to	String1 >= String2	Boolean
Not equal to	String1 <> String2	Boolean
Boolean and	Boolean1 & Boolean2	Boolean
Boolean or	Boolean1 \| Boolean2	Boolean
Boolean not	! Boolean	Boolean
Negation	- Numeric	Numeric
Addition	Numeric1 + Numeric2	Numeric
Subtraction	Numeric1 - Numeric2	Numeric
Multiplication	Numeric1 * Numeric2	Numeric
Division	Numeric1 / Numeric2	Numeric
Power	Numeric1 ^ Numeric2	Numeric
String concatenation	String1 + String2	String

Visionary User's Guide, version 1.0
Copyright © 1998, Informix Software, Inc. All rights reserved.