[odb-users] Concatenation of columns

[Reza Jahanbakhshi]

Hi,

Concatenation syntax varies from one DBMS to another. Is there any facility
in ODB query language to do this in a cross DBMS manner? I think
overloading of operator | could be a good candidate.

-- SQL Server / Microsoft Access
SELECT FirstName + ' ' + LastName As FullName FROM Customers

-- Oracle
SELECT FirstName || ' ' || LastName As FullName FROM Customers

-- MySQL
SELECT CONCAT(FirstName, ' ', LastName) As FullName FROM Customers