Property operators
Property operator is a syntax construct that describes an operator creating a property.
Property operators can be divided into context dependent and context independent.
Context dependent operators
Context dependent property operators can be part of expressions and use common parameters (context). These operators are:
- Arithmetic operators
[]operatorACTIVE TABoperatorAGGRoperatorCASEoperatorCONCAToperatorEXCLUSIVEoperatorGROUPoperator (withoutBYblock)IFoperatorIF ... THENoperatorISCLASSoperatorJOINoperatorJSONoperatorLIKEoperatorMAXoperatorMINoperatorMULTIoperatorOVERRIDEoperatorPARTITIONoperatorPREVoperatorRECURSIONoperatorROUNDoperatorSTRUCToperatorUNGROUPoperator- Type conversion operator
AND,OR,NOT,XORoperatorsIS,ASoperators- Change operators
- Comparison operators
Context independent operators
Context independent property operators differ from the context dependent ones in that they do not just use the upper parameters but define the parameters themselves. As a result, they cannot be part of expressions and can only be used in the = statement and the JOIN operator: