String concatenation operator

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

SELECT firstname || ' ' || lastname FROM employee 

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.