Concatenation: Operators
Database | Operator/Function | Notes |
---|---|---|
Access 2000 | + or & | |
DB2 8.1 | || or CONCAT() | |
Firebird 1.5 | || | |
FrontBase 4.1 | || | |
MySQL 4.0 – 4.1 | CONCAT() | |
Oracle 9.2 | || or CONCAT() | |
PostgreSQL 7.4 | || | |
SQL Server 2000 | + | |
SQLite 2.8 | || | |
Sybase ASE 12.5 | || or + |