Manual

Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.

You can log in there with your existing account of this site.

The content remains free of charge.

6.1. Constants, Functions, Operators, mathematical expressions 6.1.1. Fortran Syntax
Prev	Next

Fortran syntax

.EQ.	eq ual (equal)
.GT.	g reater t han (greater than)
.GE.	g reater e qual (greater equal)
.LT.	l ower t han (lower than)
.LE.	l ower e qual (lower equal)
.AND.	(both conditions - right and left of .AND. - must be filled out)
.OR.	(one of the two conditions - right or left of .OR. - must be filled out)
.NE.	n ot e qual (unequal)

The following examples show key values:

```
(ERP_PDM_NUMBER.NE.'')
```
The expression is true, if the respective field of the column ERP_PDM_NUMBER is not equal empty.
```
((ERP_PDM_NUMBER.NE.'').AND.(ACTIVE_STATE.EQ.1))
```
The expression is true, if the respective field of the column ERP_PDM_NUMBER is not equal empty AND the respective field of the column ACTIVE_STATE has the value 1 (=Released).
```
(PRICE.LT.0.4)
```
The expression is true, if the respective field of the column PRICE has a value lower or equal than 0,4.
```
(REQUESTED_STATE.EQ.2) 
```
The expression is true, if the respective field of the column REQUESTED_STATE has the value 2 (=Expired).
```
((ACTIVE_STATE.EQ.1).AND.(LOCATION1.NE.''))
```
The expression is true, if the respective field of the column ACTIVE_STATE has the value 1 (=Released) AND the respective field of the column LOCATION1 is not equal empty.
```
(CONTAINS(ERP_PDM_NUMBER,'AA').EQ..TRUE.)
```
The expression is true, if the respective field of the column ERP_PDM_NUMBER contains the substring 'AA'.
```
(CONTAINS(ERP_PDM_NUMBER,'AA').EQ..FALSE.)
```
The expression is true, if the respective field of the column ERP_PDM_NUMBER does NOT contain the substring 'AA'.

Prev	Up	Next
6.1. Constants, Functions, Operators, mathematical expressions	Home	6.1.2. SQL Syntax