Assignment Statement

The assignment statements are =, +=, -=, and :=. They assign values to variables. Not available in expressions.

s

Syntax

variable = value
variable += value
variable -= value
variable := value

value is the value you want to assign. It can be any constant or expression, including a null value.

Remarks

= assigns value to variable.

+= adds value to variable.

-= subtracts value from variable.

:= concatenates value to the end of variable.

To assign a null value to a variable, use this syntax:

variable = @NULL

To assign a character string containing only the character used to represent the null value to a variable, use this syntax:

variable = @NULL.STR