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.