Array operators

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » SQL language elements » Operators

Array operators

expression || expression Array concatenation (two vertical bars). If either array is NULL, it is treated as a zero-length array for concatenation.

Standards and compatibility

SQL/2008 The || operator is the SQL/2008 concatenation operator. However, in the SQL standard, if either operand of || is the NULL value, then the result of the concatenation is also NULL. With SQL Anywhere, the || operator treats NULL as a zero-length array.

UNNEST array operator

Discuss this page in DocCommentXchange.

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0