SQL adaptation guide For SQL SERVER 2005, 2008, 2012 / Data manipulation |
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
The database interface detects double-pipe operators in SQL statements and converts them to a plus sign automatically.