### Not Equal operator

Basic and Crystal syntax.

##### Usage

`x<>y`

x is not equal to y.

The Not Equal operator tells the program to evaluate an expression (x<>y) and return a TRUE (if x is not equal to y) or FALSE (if x is equal to y).

##### Examples

The following examples are applicable to both Basic and Crystal syntax:

`{orders.ORDER AMOUNT} <> 400`

TRUE, where {orders.ORDER AMOUNT} is equal to 200 or {orders.ORDER AMOUNT} is equal to 401, etc.

`{orders.ORDER AMOUNT} <> 400`

FALSE, where {orders.ORDER AMOUNT} is equal to 400.

`{file.DAY} <> "Thursday"`

TRUE, when {file.DAY} = "Friday".

`{file.DAY} <> "Thursday"`

FALSE, when {file.DAY} = "Thursday".

`{file.ONHAND} <>0`

TRUE, where the value of {file.ONHAND} is 10 or -5.

`{file.ONHAND} <>0`

FALSE, where the value of {file.ONHAND} is zero.

`{file.AVAILABLE} - {file.USED} <>10`

TRUE, where the value of the {file.AVAILABLE} field less the value of the {file.USED} field gives a result other than 10.

`{file.AVAILABLE} - {file.USED} <>10`

FALSE, where it gives a value of 10.

##### Comments

This operator is often used with If-Then-Else operators. For example in Crystal syntax:

If {file.SEX} <> "M" Then
"FEMALE"
Else
"MALE"

Prints the word "FEMALE" if the value in the {file.SEX} field is not equal to "M", and prints the word "MALE" in all other situations.

###### Related topics

Formula 5

Formula 11

Formula 15

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com