Data operators

Introduction

In Starcounter SQL, the most common operators on data are implemented.

Arithmetic Operators

The standard arithmetic operators, plus (+ x), minus (- x), addition (x + y), subtraction (x - y), multiplication (x * y) and division (x / y), are supported for all numerical types:
1
SELECT (e.Salary * 12) / 365 FROM Employee e
Copied!
For the expected datatypes of an arithmetic operation, see Datatypes.

String Concatenation

String concatenation (x || y) is supported. See example below.
1
SELECT e.FirstName || ' ' || e.LastName FROM Employee e
Copied!