Assignment operator

An assignment operator is used to replace the value of an existing variable (operand1) with a new value (operand2). he use of an assignment operator is restricted to expressions used within the FIELDS keyword only.

Note

Use of an assignment operator is not allowed within an expression specified using the WHERE keyword.

The assignment operator (:=) is used to perform an explicit conversion from one data-type to another. The value of the source operand (operand1) is converted into the data-type specified by the target variable (operand2). The rules for data conversion are provided earlier in this chapter.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*