Teradata Concatenate Syntax and Example

Опубликовано: 11 Октябрь 2024
на канале: ETL-SQL
975
17

Free SQL Pattern Training: https://etlsql.kartra.com/page/sps-fr...

In Teradata, we can use concatenation operator to link multiple string or numeric or expression values into single value. Input for concatenate can be two or more but output of concat is always one. In Teradata, concatenate operator is represented by "||" i.e two vertical lines. You can also use '!!' i.e. two exclamation mark however it is not recommended to use it. In this post we will see syntax and examples of various scenarios where concatenate can be used.

Reference : https://etl-sql.com/teradata-concaten...