6.1.1. Fortran Syntax

Fortran syntax

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

The following examples show key values:

```
(ERP_PDM_NUMBER.NE.'')
```
The expression is true if the relevant field in the ERP_PDM_NUMBER column is not empty.
```
((ERP_PDM_NUMBER.NE.'').AND.(ACTIVE_STATE.EQ.1))
```
The expression is true if the relevant field in the ERP_PDM_NUMBER column is not empty AND the relevant field in the ACTIVE_STATE column has the value 1 ( =released [Released] ).
```
(PRICE.LT.0.4)
```
The expression is true if the relevant field in the PRICE column has a value less than or equal to 0.4.
```
(REQUESTED_STATE.EQ.2) 
```
The expression is true if the relevant field in the REQUESTED_STATE column has the value 2 ( =expired [Expired] ).
```
((ACTIVE_STATE.EQ.1).AND.(LOCATION1.NE.''))
```
The expression is true if the relevant field in the ACTIVE_STATE column has the value 1 ( =released [Released] ) AND the relevant field in the LOCATION1 column is not empty.
```
(CONTAINS(ERP_PDM_NUMBER,'AA').EQ..TRUE.)
```
The expression is true if the relevant field in the ERP_PDM_NUMBER column contains the substring 'AA'.
```
(CONTAINS(ERP_PDM_NUMBER,'AA').EQ..FALSE.)
```
The expression is true if the relevant field in the ERP_PDM_NUMBER column does NOT contain the substring 'AA'.

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