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 + |