The following are the string operators in ElevateDB, ordered by their operator precedence:


Examples

---

-- The following uses the +
-- operator to format the output
-- of one of the SELECT column
-- expressions

SELECT LastName+', '+FirstName+' '+Initial AS FullName,
DateOfBirth
FROM Employees
ORDER BY FullName

SQL 2003 Standard Deviations

---

The following areas are where ElevateDB deviates from the SQL 2003 standard: