String concatenation operator

Informix®

The Informix concatenation operator is the double pipe ( || ):

SELECT firstname || ' ' || lastname FROM employee 

Microsoft™ SQL Server

The Microsoft SQL Server concatenation operator is the plus sign:

SELECT firstname + ' ' + lastname FROM employee 

Solution

The database interface detects double-pipe operators in SQL statements and converts them to a plus sign automatically.

To disable Informix emulation, consider implementing a FUNCTION that returns the DB-engine specific concatenation operator.