Table 1: Comparison operators - HxGN EAM - Version 11.07.01 - Customization & Programming - Hexagon

HxGN EAM Connector Grid Services Help

Language
English
Product
HxGN EAM
Search by Category
Customization & Programming
HxGN EAM Version
11.7.1

Operator

SQL Equivalent

=

= (equal)

IS EMPTY

IS NULL

NOT EMPTY

IS NOT NULL

CONTAINS

LIKE '%value%"

BEGINS

LIKE 'value%'

ENDS

LIKE ;%value'

IN

For numbers: IN (1,2,3) or for text: IN ('a', 'b', 'c')

!=

!= (not equal)

%lt;

< (less than)

>

> (greater than)

>= or =>

>= (greater or equal)

=&lt; or &lt;=

<= (less than or equal)