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.