Notes:

String concatentation is one example. The SQL standard is the double pipe, but Microsoft SQL Server uses the addition operator, and MySQL uses the CONCAT method.