CONCAT SQL Function

Concatenation is alternatively represented by the double pipe operator ( || ).

This operator is native on Oracle. USoft converts the double pipe operator when running on other RDBMS platforms. The operator is placed between the arguments and may be repeated any number of times:

(2 arguments)

(Multiple arguments)

On MS SQL Server, concatenation is alternatively represented by the plus operator ( + ).

USoft does NOT convert the plus operator when running on other RDBMS platforms.

The operator is placed between the arguments and may be repeated any number of times:

(2 arguments)

(Multiple arguments)